Re: SQL statement example request

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.