Dave, Try something like this: SELECT * FROM t1 LEFT JOIN t2 ON t2.id = t1.id WHERE t2.id is NULL
HTH. Dan. 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