Yurttas/PL/DBL/oracle/F/01/Company-B/q05.sql
Jump to navigation
Jump to search
1REM
2REM q05.sql
3REM
4REM Find all employees who live in the same City and
5REM on the same Street as their Manager.
6REM
7
8SELECT E1.employeename
9FROM Employee E1, Manages M, Employee E2
10WHERE E1.employeename = M.employeename
11 AND M.managername = E2.employeename
12 AND E1.Street = E2.Street
13 AND E1.City = E2.City;