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
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