RE: Use for SQL?

Charles, the parent account is what is most important in terms of the
ranking, in the case of the BK. I WILL post more as I get into it.

Thank you,
Phil

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Wilt, Charles
Sent: Wednesday, December 20, 2006 4:42 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Use for SQL?

Can the SQL be able to discern where it has a number of 
Burger-Kings and
aggregate them?

Can you?

If so then how?

Normally, in this type of situation, I've got multiple order account
numbers with the same A/P account number.  In which case it is a simple
matter to have

Select apnbr, sum(amount)

From file

Group by apnbr

But it doesn't sound like you have that.

You also said, "For the sake of this report, it doesn't matter which
account number is listed for the total Burger-Kings." which is a little
confusing.

If you want more help, you'll have to give us some idea of what the data
looks like and maybe some samples of the input and what you want output.

HTH,

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121