Re: The most efficient way to put this?

On 2002-03-05 "Arsalan Zaidi" <azaidi@directi.com> wrote

>SELECT DISTINCT ON (aa.a) aa.a, aa.b, aa.c FROM aa WHERE aa.a NOT IN
(select
>zz.a from zz);

Does this work?

select distinct on (aa.a) aa.a, aa.b, aa.c
  from aa left join zz on aa.a = zz.a
  where zz.a isnull

--
Rolf