Re: Rows not in a table

Hi Roland,

Try using the outer join ie:

select ....
where tab1.fld1 = tab2.fld1 (+) and
tab2.fld1 is null

This returns all rows from tab1 where the coresponding field in tab2 are null is don't exist.

Nevin Hahn
nhahn_at_evoke.com

<buurd_at_my-deja.com> wrote in message news:8pim3o$7vm$1_at_nnrp1.deja.com...
> Hi!
> What is the best way of getting all the rows not in a table? I've got
> three tables. One table holds SOME of the possible combination of the
> other two. Now I have to find out witch combinations not in the other
> two. The only i got working is to take ALL posslble combination MINUS
> the one in the table but it seems like its slow to do the (almost) same
> query twice. Are there any better way to sovle this problem??
>
> Thanks in advance
> Roland Carsson
>
> --
> Roland Carlsson
> Jönköping
> Sweden
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Sep 11 2000 - 17:56:00 CDT