Yurttas/PL/DBL/mysql-f-2010/01/BankTwo/u04.sql

 1/*
 2REM
 3REM u04.sql
 4REM
 5REM Delete all accounts at branches located in Caldwell.
 6REM
 7*/
 8
 9\. set-db.sql
10
11DELETE FROM Depositor
12WHERE branchname IN (SELECT branchname
13                     FROM Branch
14                     WHERE branchcity = 'Caldwell');