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
speak. I ended up banging it out in RPG. I would like to see how you
would have done it with a SQL statement.

I have a header file with a total field. This total should match the sum
the transactions in a detail file. I needed to list all header records
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

Thanks in advance, Tim

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
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.

This thread ...


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