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

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