Posted by Razvan Socol on 02/15/06 17:09
Hi, Brian
I think that you wanted to write "WHERE I.Key IS NULL" (instead of
"WHERE D.Key IS NULL"). In this case, you can use something like this:
SELECT ...
FROM DataTable WHERE Key NOT IN (
SELECT Key FROM InactiveTable
)
Razvan
PS. I assume that the "Key" column does not allow NULL-s.
[Back to original message]
|