a guest Dec 25th, 2017 89 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;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand