- Select Distinct Pnumber
- From PROJECT
- Where Pnumber in (
- Select Pnumber
- From PROJECT, EMPLOYEE, DEPARTMENT
- where Dnum = Dnumber
- and Mgr_ssn = Ssn
- and Lname = 'Smith')
- or
- Pnumber in(
- Select Pno
- From WORKS_ON, EMPLOYEE
- where Essn = Ssn
- and Lname = 'Smith')
By: AndyGrimm | Date: Oct 29 2010 01:30 | Format: None | Expires: never | Size: 269 B | Hits: 775