Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- e.emp_id, e.emp_name, e.emp_surname1, e.emp_surname2,
- j.job_name, u.ubi_name, d.dep_name, por.por_type,
- b.bank_name, bb.bbank_name
- from public.employee e
- left join public.ubi u on e.ubi_id = u.ubi_id
- left join public.jobs j on e.job_id = j.job_id
- left join public.department d on e.dep_id = d.dep_id
- left join public.percent por on e.por_id = por.por_id
- left join public.bank b on e.bank_id = b.bank_id
- left join public.bbank bb on e.bbank_id = bb.bbank_id
- where e.ubi_id is not null
- and e.job_id is not null
- and e.dep_id is not null
- and e.por_id is not null
- and e.bank_id is not null
- and e.bbank_id is not null
- order by e.emp_id asc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement