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

[Frank Bax]

At 10:19 AM 7/11/06, [EMAIL PROTECTED] 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;


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq