- 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: 1016
Latest pastes
3 months ago
5 months ago
20 months ago
22 months ago
26 months ago