Re: How to find entries missing in 2nd table? - Mailing list pgsql-sql

> 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.