Yurttas/PL/DBL/mssql/F/01/SPJ/q12.sql

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