--- Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
> > >> 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;
> > >
> >
> >
> > Or
> > (SELECT controller_id FROM control)
> > EXCEPT
>
> Good point! But don't forget to include the list. :-)
>
> Regards,
>
> Richard Broersma Jr.
> > (SELECT controller_id FROM datapack)
> > ?
> >
> > --
> > Milen A. Radev
> >
>
>
---------------------------(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
