diff options
Diffstat (limited to 'db_demo/sql/views/cr_vw_person.sql')
| -rw-r--r-- | db_demo/sql/views/cr_vw_person.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/db_demo/sql/views/cr_vw_person.sql b/db_demo/sql/views/cr_vw_person.sql new file mode 100644 index 0000000..0f8a973 --- /dev/null +++ b/db_demo/sql/views/cr_vw_person.sql @@ -0,0 +1,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
+;
\ No newline at end of file |