Re: How to find entries missing in 2nd table?

At 10:19 AM 7/11/06, alex-lists-pgsql@yuriev.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;