Re: Select * from t1.id where not equal to t2.id ???

From:	Miles Thompson	Date:	Sat, 03 Aug 2002 12:37:17 +0000
Subject:	Re: Select * from t1.id where not equal to t2.id ???
References:	1	Groups:	php.db
Request:	Send a blank email to php-db+get-20969@lists.php.net to get a copy of this message

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