> 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.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
