Re: SQL question

You just have to be sure not to use the

select *

syntax - list the individual fields/columns instead. If the names are the same in each file, qualify them with the file name or and alias name for the file.

Even in Query/400 you could do field selection, which'd accomplish the same thing.

HTH
Vern

-------------- Original message ----------------------
From: Michael_Schutte@xxxxxxxxxxxx

If I understand correctly... you are not going to be able to do what you
want...

When you do a join, the secondary file will get joined to the primary file
where matches occur. So the sales tax you talk of will be joined to every
record. IMO, you should change your logic. First to get the sales tax
for the whole order, then separately process the primary file you speak of.



Michael Schutte
Admin Professional
Bob Evans Farms, Inc.
"The Secret's the Sauce! Enjoy our new Bob-B-Q Pulled Pork Knife & Fork
Sandwich!"


rpg400-l-bounces@xxxxxxxxxxxx wrote on 01/03/2008 02:51:41 PM:

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.

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