- 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: 1271
Latest pastes
16 months ago
18 months ago
32 months ago
33 months ago
35 months ago