Re: SQL statement example request

[Michael_Schutte@xxxxxxxxxxxx]

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.