Why not: select * from table1 where table1.id != table2.id
or it may be necessary to incorporate a fragment of table2 select table1.8, table2.id from table1, table2 where table1.id != table2.id Note this tests against only one the current table2.id, not all of them. So what do you really want to do? Miles Thompson At 08:07 AM 8/3/2002 +0100, Dave Carrera wrote: >High all > >I cant seem to get this sql working. > >I am trying to pull everything from table 1 (t1) where t1.id is not >equal to table 2 (t2) id > >I cant find examples anywhere. > >Any help or guidance with this as always is very much appreciated. > >Thanks in Advance > >Dave C -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php