Yurttas/PL/DBL/oracle/F/01/SPJ/q010.sql
Jump to navigation
Jump to search
1REM
2REM q010.sql
3REM
4REM Get project names for projects supplied by suppliers
5REM 'S01' or 'S03'.
6REM
7
8SELECT DISTINCT jname
9FROM Projects
10WHERE jn IN (SELECT jn
11 FROM Shipments
12 WHERE sn='S01'
13 OR sn='S03');