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
;