Guest User

Untitled

a guest
Jun 19th, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. [work_order]
  2. work_order_id
  3.  
  4. [link_person_wo]
  5. work_order_id
  6. person_id
  7.  
  8. [person]
  9. person_id
  10. type
  11.  
  12. 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