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

  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')
Latest pastes
17 days ago
18 days ago
20 days ago
26 days ago
2 months ago