> 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;
Regards,
Richard Broersma Jr.