SELECT t1.* FROM t1 LEFT JOIN t2 ON t1.id=t2.id WHERE t2.id IS NULL
The left join retains all records in the first table regardless of matches in the second. You then filter out those records with a null value in a table 2 field.
On Apr 15, 2004, at 3:46 PM, Justin Palmer wrote:
Hi,
Is it possible to select all records from one table that don't have an entry in another table. Something like:
SELECT t1.* FROM 'TABLE1' AS t1, 'TABLE2' AS t2 WHERE t1.cv = 1 AND t1.id != t2.id
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
