got contact info working

1 files changed, 17 insertions, 0 deletions

diff --git a/sql/views/resume.contactinfo_v.sql b/sql/views/resume.contactinfo_v.sql
new file mode 100644
index 0000000..4c4eb79
--- /dev/null
+++ b/sql/views/resume.contactinfo_v.sql
@@ -0,0 +1,17 @@
+drop view resume.contactinfo_v cascade;
+
+create or replace view resume.contactinfo_v as
+select c.id,
+    c.user_id,
+    c.address,
+    c.city,
+    c.state_id,
+    s.state as state_name,
+    s.abbr as state_abbr,
+    c.phone,
+    c.email,
+    c.visastatus_id,
+    v.status as visastatus
+from resume.contactinfo c
+inner join resume.states s on c.state_id = s.id
+inner join resume.visastatus v on c.visastatus_id = v.id;