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