Mysql query

[sean zang]

Dear All;
MYSQL Query does not support following statements
" SELECT * FROM table1 WHERE id NOT IN (SELECT id FROM table2);
SELECT * FROM table1 WHERE NOT EXISTS (SELECT id FROM table2 where table1.id=table2.id) "
Does any JDBC expert tell me how to replace those queries with MYSQL statements?
Sean
thanks in advance

[SoonAnn Lim]

Hi, this is the answer i think it works.
SELECT table1.* FROM table1 LEFT JOIN table2 ON table1.id=table2.id where table2.id IS NULL;
You can find this on Mysql homepage.

[sean zang]

Hi,SoonAnn Lim
thanks for you reply !
I have alrady solved by coding in JDBC
Sean

[Stanley Tan]

sean zang,
Please post your code so us others can learn!