diff options
| author | Wilrik de Loose <wilrik@wilrik.nl> | 2008-05-08 19:07:50 (GMT) |
|---|---|---|
| committer | Wilrik de Loose <wilrik@wilrik.nl> | 2008-05-08 19:07:50 (GMT) |
| commit | dc6caf529031dba2dd595b64ee008ffda39737b6 (patch) | |
| tree | 9026623a73886e313097561b4bfc09f9cc77b025 /db_demo/sql/views/cr_vw_turn.sql | |
| parent | 4c0c2685a6d564c9a6170b8a56c873104046a832 (diff) | |
| download | 2iv55-dc6caf529031dba2dd595b64ee008ffda39737b6.zip 2iv55-dc6caf529031dba2dd595b64ee008ffda39737b6.tar.gz 2iv55-dc6caf529031dba2dd595b64ee008ffda39737b6.tar.bz2 | |
Tabel structuur aangemaakt
Diffstat (limited to '')
| -rw-r--r-- | db_demo/sql/views/cr_vw_turn.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/db_demo/sql/views/cr_vw_turn.sql b/db_demo/sql/views/cr_vw_turn.sql new file mode 100644 index 0000000..93485bf --- /dev/null +++ b/db_demo/sql/views/cr_vw_turn.sql @@ -0,0 +1,18 @@ +CREATE OR REPLACE VIEW vw_turn AS
+SELECT
+ ts.*,
+
+ t.key AS turnid,
+ t.elapsedtime,
+ t.holeposition,
+
+ b.key AS blockid,
+ b.description AS block
+FROM
+ tbl_turn t,
+ vw_test ts,
+ const_block b
+WHERE
+ t.testid = ts.testid AND
+ t.blockid = b.key
+;
\ No newline at end of file |