At 10:19 AM 7/11/06, alex-lists-pgsql(at)yuriev(dot)com wrote:
>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 controller.controller_id from controller
left join datapack on controller.controller_id = datapack.controller_id
where datapack.controller_id is null;