Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [work_order]
- work_order_id
- [link_person_wo]
- work_order_id
- person_id
- [person]
- person_id
- type
- SELECT work_order_id FROM linked_person_id JOIN person ON person.person_id = linked_person_id.person_id WHERE type = 'Employee' GROUP BY work_order_id
Add Comment
Please, Sign In to add comment