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

 1/*
 2REM
 3REM q071.sql
 4REM
 5REM Find all customers of the 'Perryridge' branch who have
 6REM an account but not a loan.
 7REM
 8*/
 9
10/*
11
12   MINUS is not implemented this won't work.
13
14*/
15
16(SELECT customername
17 FROM Depositor
18 WHERE branchname = 'Perryridge')
19MINUS 
20(SELECT customername
21 FROM Borrower
22 WHERE branchname = 'Perryridge');