Yurttas/PL/DBL/mysql-f-2010/01/sy/q01.sql

 1/*
 2REM
 3REM
 4REM q01.sql
 5REM
 6REM
 7*/
 8
 9\. set-db.sql
10
11SELECT DISTINCT T1a.a
12FROM TA1 T1a
13WHERE NOT EXISTS (SELECT DISTINCT T2a.b
14	          FROM TA2 T2a
15                  WHERE T2a.b NOT IN (SELECT DISTINCT T1b.b
16                                      FROM TA1 T1b
17                                      WHERE T1b.a=T1a.a));