Yurttas/PL/DBL/oracle/F/01/Company-B/q04.sql
Jump to navigation
Jump to search
1REM
2REM q04.sql
3REM
4REM Find all employees who live in the same city as
5REM the company they work for.
6REM
7
8SELECT E.employeename
9FROM Employee E, Works W, Company C
10WHERE E.employeename = W.employeename
11 AND W.companyname = C.companyname
12 AND E.city = C.city;