MySQL Query
| From: | Keith Spiller | Date: | Sun, 20 Nov 2005 02:29:25 +0000 |
| Subject: | MySQL Query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-40703@lists.php.net to get a copy of this message | ||
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