sql/views/resume.contactinfo_v.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
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;