Yurttas/PL/DBL/mysql/F/01/00/bank/BankTwo/q101.sql

 1/*
 2REM
 3REM q101.sql
 4REM
 5REM Find all customers with both loan and an account
 6REM at the 'Caldwell' branch.
 7REM
 8*/
 9
10/*
11
12   INTERSECT is not implemented this won't work.
13
14*/
15
16\. set-db.sql
17
18(SELECT customername
19 FROM Depositor
20 WHERE branchname = 'Caldwell')
21INTERSECT
22(SELECT customername
23 FROM Borrower 
24 WHERE branchname = 'Caldwell');