RE: [PHP-DB] MySQL Query

[Bastien Koert]

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

From: "Keith Spiller" <[EMAIL PROTECTED]>
To: "[PHP-DB]" <php-db@lists.php.net>
Subject: [PHP-DB] MySQL Query
Date: Sat, 19 Nov 2005 19:29:25 -0700

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

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php