Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT LNAME, FNAME, ADDRESS FROM EMPLOYEE WHERE EXISTS
- (SELECT * FROM WORKS_ON, PROJECT, DEPT_LOCATIONS WHERE SSN=ESSN AND PNO=PNUMBER AND DNO = DNUMBER AND DLOCATION = PLOCATION)
- AND NOT EXISTS ( SELECT * FROM WORKS_ON, PROJECT, DEPT_LOCATIONS WHERE SSN = ESSN AND PNO = PNUMBER AND DLOCATION = PLOCATION AND DNUM = DNUMBER)
Add Comment
Please, Sign In to add comment