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
