Public paste
Undefined
By: AndyGrimm | Date: Oct 29 2010 01:30 | Format: None | Expires: never | Size: 269 B | Hits: 939

  1. Select Distinct Pnumber
  2. From PROJECT
  3. Where Pnumber in (
  4. Select Pnumber
  5. From PROJECT, EMPLOYEE, DEPARTMENT
  6. where Dnum = Dnumber
  7. and Mgr_ssn = Ssn
  8. and Lname = 'Smith')
  9. or
  10. Pnumber in(
  11. Select Pno
  12. From WORKS_ON, EMPLOYEE
  13. where Essn = Ssn
  14. and Lname = 'Smith')