select t1.* from table1 t1 LEFT JOIN table2 t2 on t1.id=t2.id WHERE t2.id IS NULL you can print out table2 values if you want, but they will all be NULL..
provided that table2.id and table1.id are the matches you are trying to find. Kelley Martin Moss wrote: > All, > > Am wondering if it's possible to do a query that does something like this:- > > SELECT table1.*,table2.id from Table1 AS table1,Table2 AS table2 > WHERE table1.id DOESN'T EXIST IN table2.id; > > Regards > > Marty > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003 > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]