RE: embedded SQL....

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 prohibited.