db_demo/sql/views/cr_vw_turn.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
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
;