blob: 3996188d8f86811f8d12c1b52638127b823b0725 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
CREATE OR REPLACE VIEW vw_test AS
SELECT
p.*,
t.key AS testid,
g.key AS gametypeid,
g.headtracking,
g.stereo,
g.shadow,
b.key AS boxsizeid,
b.description AS boxsize
FROM
tbl_test t,
vw_person p,
const_gametype g,
const_boxsize b
WHERE
t.personid = p.personid AND
t.gametypeid = g.key AND
g.boxsizeid = b.key
;
|