It might help is you can give us more information about the files and
how they are related. Is it a one-to-one relationship or a one-to-many?
As Michael posted it's one-to-many the detail fields will be returned
for each match.
Rick
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Berman
Sent: Thursday, January 03, 2008 1:52 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: SQL question
HI I have 2 files that are to be joined. in the secondary file there is
a field that is used in the report but I only want to show it one time.
To clarify, I am showing the invoice number and other details, while the
sales tax field is in the second file. I only wish to show this sales
tax once per order for the report and as wel to tally this sales tax
field as well as other fields.
I am unsure how to do this in SQL. In query the sales tax will show
each time.
I can always write an RPG program to do this but was looking for the
quicker method.
Thanks,
---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try
it now.
--
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.
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.
midrange.com
