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