Re: How to find entries missing in 2nd table?

Richard Broersma Jr написа:
>> Hi,
>>     I realize I probably lost my marbles but I've been having a god
>> awful time with a single query:
>>
>> control:
>>     ....
>>     ....
>>     controller_id    pk;
>>
>>
>> datapack:
>>
>>     controller_id    fk;
>>     ....
>>     ....
>>     ....
>>
>> I need to get all entries from the table control that are not listed in
>> datapack.
> 
> SELECT C.CONTROLLER_ID
> 
> FROM CONTROL AS C 
>   LEFT JOIN DATAPACK AS D ON ( C.CONTROLLER_ID = D.CONTROLLER_ID)
> 
> WHERE D.CONTROLLER_ID IS NULL;
> 


Or
(SELECT controller_id FROM control)
EXCEPT
(SELECT controller_id FROM datapack)
?

-- 
Milen A. Radev