Yurttas/PL/DBL/oracle/F/01/Bank/q100.sql
Jump to navigation
Jump to search
1REM
2REM q100.sql
3REM
4REM Find all customers with both loan and an account
5REM at the 'Perryridge' branch.
6REM
7
8SELECT customername
9FROM Depositor
10WHERE branchname = 'Perryridge'
11 AND customername IN (SELECT customername
12 FROM Borrower
13 WHERE branchname = 'Perryridge');