I believe the following query will do what you want it to do:
SELECT t1.id from table1 as t1 LEFT JOIN table2 as t2 on t2.t1id = t1.id
AND t2.id = 9 WHERE t2.id IS NULL;
More information can be found at
http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html about sub-select
work arounds.
Message -
From: Jesper Ă–man [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 11, 2002 5:20 PM
Subject: Subselect translation?
Hi, I have a little problem making a query with only one SELECT phrase;
I wan't to solve this with a JOIN since sub-selects are not supported in
MySQL