SHARE
TWEET

Untitled

a guest Jun 18th, 2019 84 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select
  2.   e.emp_id, e.emp_name, e.emp_surname1, e.emp_surname2,  
  3.   j.job_name, u.ubi_name, d.dep_name, por.por_type,
  4.   b.bank_name, bb.bbank_name
  5. from public.employee e
  6. left join public.ubi u on e.ubi_id = u.ubi_id
  7. left join public.jobs j on e.job_id = j.job_id
  8. left join public.department d on e.dep_id = d.dep_id
  9. left join public.percent por on e.por_id = por.por_id
  10. left join public.bank b on e.bank_id = b.bank_id
  11. left join public.bbank bb on e.bbank_id = bb.bbank_id
  12. where e.ubi_id is not null
  13.   and e.job_id is not null
  14.   and e.dep_id is not null
  15.   and e.por_id is not null
  16.   and e.bank_id is not null
  17.   and e.bbank_id is not null
  18. order by e.emp_id asc
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top