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

From ZCubes Wiki
Jump to navigation Jump to search
 1REM
 2REM q02.sql
 3REM
 4REM Find the name and city of of all employees who work for
 5REM 'First Bank Corporation'.
 6REM
 7
 8SELECT E.employeename, E.city 
 9FROM Employee E, Works W 
10WHERE E.employeename=W.employeename 
11  AND W.companyname='First Bank Corporation';