Hi,

I'm tring to run this query to find orphan entries.

SELECT c.eventid, e.ID 
FROM col_links c left outer join calendar_v2 e 
ON c.eventid = e.ID
LIMIT 0, 999; 

Then I have to scan the list to find entries where
e.ID equals NULL.

I was wondering if anyone know how to expand this
query with a WHERE clause that would find just the
orphan instances.

Thanks,

Keith

Reply via email to