Yurttas/PL/DBL/oracle/F/01/Company-B/q04.sql

From ZCubes Wiki
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;