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
So in this mock example there is an id in one table, but the id is not
in another table (The second id will be in the second table someday just
not today).
Not sure if this is possible at all or not, but thought I would ask.
Regards,
Justin Palmer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
