leider gibte es alle drei Befehle nicht in
MySQL.
Tja, da war ich dann wohl etwas schlampig. Aber es gibt dutzende Anleitungen, wie man nachbaut, z.b. hier:
http://www.bitbybit.dk/carsten/blog/?p=71
Zitat:
Performing a MINUS
To transform the statement
Code:
SELECT member_id, name FROM a
MINUS
SELECT member_id, name FROM b
into something that
MySQL can process, we can utilize subqueries (available from
MySQL 4.1 onward). The easy-to-understand transformation is:
Code:
SELECT DISTINCT member_id, name
FROM a
WHERE (member_id, name) NOT IN
(SELECT member_id, name FROM table2);
Of course, to any long-time
MySQL user, this is immediately obvious as the classical use-left-join-to-find-what-isn’t-in-the-other-table:
Code:
SELECT DISTINCT a.member_id, a.name
FROM a LEFT JOIN b USING (member_id, name)
WHERE b.member_id IS NULL
which tends to be a lot more efficient.
Ansonsten sehe ich in Deinen weiteren Versuchen nichts mehr von der urspünglichen Anforderung. Was brauchst Du denn nun?