Re: SQL help

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

I think I have confused us both. If there is no relationship between BUS and
CONT there can be no relationship between BUS and OCCU. However there can be
a relationship between BUS and CONT with no relationship between CONT and
OCCU. The last one is the one i'm looking for.

On 2/8/07, John Joiner <john@xxxxxxxxxxxxxx> wrote:
> Maybe I'm all wet, but...
>
> BUS has a relationship with CONT and CONT has a relationship with OCCU,
> but
> there is no direct relationship between BUS and OCCU. You can't get from
> BUS
> to OCCU without a CONT, so if there are BUS records without associated
> CONTs, do those BUS records have associated OCCU records?
>
> Seems to me that all you can do if figure out what is common between BUS
> and
> CONT (inner join), then find the BUS without an OCCU (exception join).
>
> JJ
>
> -----Original Message-----
> From: rpg400-l-bounces+john=thejoiners.net@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces+john=thejoiners.net@xxxxxxxxxxxx] On Behalf Of
> Alan
> Shore
> Sent: Thursday, February 08, 2007 4:01 PM
> To: RPG programming on the AS400 / iSeries
> Subject: RE: SQL help
>
> I was thinking along these same lines for my response when I realized that
> there may be BUS records that have NO CONT records as well.
> This is NOT that easy
>
>
>
> Alan Shore
>
> NBTY, Inc
> (631) 244-2000 ext. 5019
> AShore@xxxxxxxx
>
> rpg400-l-bounces@xxxxxxxxxxxx wrote on 02/08/2007 04:49:35 PM:
>
> > I think this will get you what you want (not tested)...
> >
> > select a.* from BUS a inner join CONT b on a.b1 = b.b1 exception join
> OCCU c
> > on b.c1 = c.c1
> >
> > JJ
> >
> >
> >
> > -----Original Message-----
> > From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
> > On Behalf Of Bob Bledsoe
> > Sent: Thursday, February 08, 2007 3:36 PM
> > To: rpg400-l@xxxxxxxxxxxx
> > Subject: SQL help
> >
> > 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.
> >
> >
> >
> >
> > --
> > 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.
> >
> --
> 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.
>
>
>
> --
> 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.