Yurttas/PL/DBL/oracle/F/01/Bank/q08.sql

 1REM
 2REM q08.sql
 3REM
 4REM Find all clients of banker 'Johnson', as well as the cities
 5REM in which these clients live.
 6REM
 7
 8SELECT Customer.customername, customercity
 9FROM Client, Customer
10WHERE Client.customername = Customer.customername
11  AND bankername = 'Johnson';