ProfitPress Mega CDROM2 …eeware (MSDOS)(1992)(Eng)/ProfitPress-MegaCDROM2.B6I/MAGAZINE/MISC/DBMS9103.ZIP/SQL1.MAR

Text File | 1991-01-22 | 644 b | 2 lines

SELECT a.pname, b.pname FROM part a, part b WHERE a.p# != b.p#   AND EXISTS (SELECT * FROM litem al                WHERE al.p# = a.p#                  AND b.p# IN (SELECT p# FROM litem                                WHERE i# = al.i#))   AND NOT EXISTS (SELECT * FROM litem al                    WHERE al.p# = a.p#                      AND b.p# NOT IN (SELECT p# FROM litem                                        WHERE i# = al.i#))   AND NOT EXISTS (SELECT * FROM litem bl                    WHERE bl.p# = b.p#                      AND a.p# NOT IN (SELECT p# FROM litem                                        WHERE i# = bl.i#));