Thanks your help, but I would like to do the following:
If I have is ONE same ID between the two tables, than the result it must be "empty". Egor Egorov <[EMAIL PROTECTED]> 2004-04-28 12:10 PM To: [EMAIL PROTECTED] cc: (bcc: Zoltan Gyurasits/GYO/COMP/PHILIPS) Subject: Re: SQL SELECT HELP Classification: [EMAIL PROTECTED] wrote: > > I have a query problem. I want to make a query.... > > SELECT * > FROM table1 > INNER JOIN table2 ON table1.id NOT IN table2.id > > But I can't use the "NOT IN" expression here. > > What can i do? > > I have the MySQL version 4.x I can't use subquery :( > If I've got you right you need LEFT JOIN instead of INNER JOIN. SELECT * FROM table1 LEFT JOIN table2 ON table1.id=table2.id WHERE table2.id IS NULL; -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]