Advertisement
Guest User

Untitled

a guest
Jan 16th, 2018
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. select po.id , po.short_name, pod.id, pod.short_name
  2. from pim_position pp
  3. join pim_department pd on pd.id = pp.department_id
  4. join pim_organization pod on pod.id = pd.org_id
  5. join pim_organization po on po.id = pp.organization_id
  6. where po.id <> pod.id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement