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

From ZCubes Wiki
Jump to navigation Jump to search
 1REM
 2REM q071.sql
 3REM
 4REM Find all customers of the 'Perryridge' branch who have
 5REM an account but not a loan.
 6REM
 7
 8(SELECT customername
 9 FROM Depositor
10 WHERE branchname = 'Perryridge')
11MINUS 
12(SELECT customername
13 FROM Borrower
14 WHERE branchname = 'Perryridge');