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