Re: Select * from t1.id where not equal to t2.id ???
| From: | Dan Koken | Date: | Sat, 03 Aug 2002 14:44:36 +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-20972@lists.php.net to get a copy of this message | ||
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