Yurttas/PL/DBL/oracle/F/01/Bank/q08.sql
Jump to navigation
Jump to search
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';