Re: SQL help

["Bob Bledsoe" <bledsoe.bob@xxxxxxxxx>]

I got short on time so I just did it the "old fashion way" but I'll keep
trying these suggestions as time permits.

Thanks



On 2/9/07, Joep Beckeringh <joep@xxxxxxxxxxxxxxxxxxx> wrote:
> select * from BUS
>   where b1 not in
>     (select b1 from CONT)
>   or b1 in
>     (select b1 from CONT
>       where c1 not in
>         (select c1 from OCCU))
>
> Joep Beckeringh
>
>
>
> Bob Bledsoe wrote:
> > I have 3 files, BUS, CONT, OCCU. BUS is tied to CONT by field b1 and
> there
> > can be more the one record in CONT for each record in BUS. CONT is tied
> to
> > OCCU by field C1. What I am trying to get is all the records ib BUSS
> that
> > have NO record in OCCU. I'm totally lost as to how to do this with SQL.
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.