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.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
;