MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » June 2008

Re: SQL statement example request



fixed


With tmpDetail as
(select order, sum(total) as total from detail group by order)
select *
from header a
join detail b
on a.order = b.order
where a.total <> b.total




Michael Schutte
Admin Professional
Bob Evans Bob-B-Q: You haven't had barbeque until you've had Bob Evans
Bob-B-Q. Try our six Bob-B-Q dishes, starting at $5.99. For more
information, visit www.BobEvans.com.


midrange-l-bounces@xxxxxxxxxxxx wrote on 06/12/2008 02:58:33 PM:



Calling all SQL gurus,
I wanted to do an adhoc report using SQL earlier today. I only know the
very basics when it comes to SQL, but I what to start digging deeper so
to
speak. I ended up banging it out in RPG. I would like to see how you
guys
would have done it with a SQL statement.

I have a header file with a total field. This total should match the sum
of
the transactions in a detail file. I needed to list all header records
that
did not match, displaying the header amount and the sum of the detail.

Sounds easy, eh? And it may be. Just in case someone has nothing better
to
do...

Thanks in advance, Tim


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact