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

From ZCubes Wiki
Jump to navigation Jump to search
 1REM
 2REM q06.sql
 3REM
 4REM Find all customers of the 'Perryridge' branch, i.e., find
 5REM everyone who has an account, a loan, or both.
 6REM
 7
 8(SELECT customername
 9 FROM Depositor
10 WHERE branchname = 'Perryridge')
11UNION
12(SELECT customername
13 FROM Borrower
14 WHERE branchname = 'Perryridge');