Re: embedded SQL....

I wonder when IBM will support FULL INNER JOIN...that would make life so
much easier



Wes
<Rick.Chevalier@xxxxxxxxxxxxxxx> wrote in message
news:C84145CBB2AC60478B7805C1BD0656CA02536C0F@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>
> Jake,
>
> I don't know what the other three categories are you need.  I think I
> missed a post or two.  Add the join to the customer master from Michaels
> query and see if that doesn't get what you need.
>
> Rick
>
> > -----Original Message-----
> > From: rpg400-l-bounces@xxxxxxxxxxxx
> > [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On
Behalf Of Jake M
> > Sent: Friday, April 14, 2006 3:20 PM
> > To: RPG programming on the AS400 / iSeries
> > Subject: Re: [RPG400-L] embedded SQL....
> >
> > Rick,
> > I tried your query....I think we are really close but missing
> > something...I am about to try Michael's suggestion...Rick's
> > results..I am missing the other three categories from the
> > CHE1000 customer...but I think we are getting close....I will
> > be back..
> >
> >    CHE1000    SI            49318.00    15354.82
> >    CHE1100    MR            148617.72    136854.88
> >    CHE1100    MS            80596.88    109563.10
> >    CHE1100    OR            255863.90    220504.07
> >    CHE1100    SI            20370.96    80965.14
> >    CHE1200    MR            23624.86    null
> >    CHE1200    MS            8836.08    null
> >    CHE1200    OR            17024.84    null
> >    CHE1200    SI            35559.54    null
> >
> >
>
> Privileged and Confidential.  This e-mail, and any attachments there to,
is intended only for use by the addressee(s) named herein and may contain
privileged or confidential information.  If you have received this e-mail in
error, please notify me immediately by a return e-mail and delete this
e-mail.  You are hereby notified that any dissemination, distribution or
copying of this e-mail and/or any attachments thereto, is strictly prohibite
d.
>
> -- 
> 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.
>
>