Yurttas/PL/DBL/mysql-f-2010/01/SPJ/q12.sql

 1/*
 2REM
 3REM q12.sql
 4REM
 5REM Delete all shipments for suppliers in 'London'.
 6REM
 7*/
 8
 9\. set-db.sql
10
11DELETE FROM Shipments
12WHERE SN IN (SELECT SN 
13             FROM Suppliers
14             WHERE City = 'London');