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