Guest User

Untitled

a guest
Dec 25th, 2017
156
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT lastName, firstName FROM Consultants C, Consultants_Projects CP, Projects P, Clients_Projects CP1, Clients C1
  2. WHERE CP.serialNumber = C.serialNumber
  3. AND P.projectID = CP.projectID
  4. AND CP1.projectID = P.projectID
  5. AND C1.referenceNumber = CP1.referenceNumber
  6. AND C.title = Practitioner
  7. AND C1.clientSector = PUBLIC;
Add Comment
Please, Sign In to add comment