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

From ZCubes Wiki
Jump to navigation Jump to search
 1REM
 2REM q091.sql
 3REM
 4REM Find all customers who have a loan at the bank and
 5REM the cities in which they live.
 6REM
 7
 8SELECT B.customername, C.customercity
 9FROM Borrower B, Customer C
10WHERE B.customername = C.customername;