Geschachtelte Selects

[Rouven]

Hi,

select e.id from experiment e where e.id != ALL (select target_exp_id from res_has_experiment);

Also instinktiv stößt mir da mal der !=-Operator auf, der lautet in SQL normalerweise <>, vielleicht probierst du es mal damit.
Das MySQL-Handbuch listet selber:

NOT IN is an alias for <>  ALL. Thus, these two statements are the same:

SELECT s1 FROM t1 WHERE s1 <> ALL (SELECT s1 FROM t2);
SELECT s1 FROM t1 WHERE s1 NOT IN (SELECT s1 FROM t2);

MfG
Rouven