Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select po.id , po.short_name, pod.id, pod.short_name
- from pim_position pp
- join pim_department pd on pd.id = pp.department_id
- join pim_organization pod on pod.id = pd.org_id
- join pim_organization po on po.id = pp.organization_id
- where po.id <> pod.id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement