- 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: 1023
Latest pastes
4 months ago
5 months ago
21 months ago
22 months ago
27 months ago