Yurttas/PL/DBL/mysql-f-2010/01/sy/q01.sql
Revision as of 02:23, 4 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">→REM REM REM q01.sql REM REM: \. set-db.sql SELECT DISTINCT T1a.a FROM TA1 T1a WHERE NOT EXISTS (SELECT DISTINCT...")
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));