blob: 0f8a97312cc77dabb26b0d10d2803c087b5e4d39 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
CREATE OR REPLACE VIEW vw_person AS
SELECT
p.key AS personid,
p.c_experience,
p.w_experience,
a.key AS agegroupid,
a.description AS agegroup
FROM
tbl_person p,
const_agegroup a
WHERE
p.agegroupid = a.key
;
|