Yurttas/PL/DBL/postgres/F/01/SPJ/q13.sql

 1/*
 2REM
 3REM q13.sql
 4REM
 5REM Delete all projects for which there are no shipments.
 6REM
 7*/
 8
 9SELECT current_schema();
10SET search_path to "spj";
11
12DELETE FROM Projects
13WHERE JN NOT IN (SELECT JN
14                 FROM Shipments);