[PHP-DB] Select * from t1.id where not equal to t2.id ???

2002-08-03 Thread Dave Carrera 

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

Re: [PHP-DB] Select * from t1.id where not equal to t2.id ???

2002-08-03 Thread Miles Thompson 

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