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
;