db_demo/sql/views/cr_vw_person.sql


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.cexperience,
  p.wexperience,

  a.key AS agegroupid,
  a.description AS agegroup
FROM
  tbl_person p,
  const_agegroup a
WHERE
  p.agegroupid = a.key
;