Re: Comparing two detail totals in SQL

[Pete Helgren <Pete@xxxxxxxxxx>]

Stellar Rob!  You nailed it.

Cool.  Name the tables, describe them and use them in the resultant 
query.  Very nice.  Better yet, I understand it...

Thanks for the help.

Pete



rob@xxxxxxxxx wrote:
> With sumRec1 as (
> select empID1, code1, sum(quantity) as tot1
> from rec1 where recDate Between
> 070701 and 080410
> group by empID1, code1
> order by empID1,code1
> ),
> SumRec2 as(
> select empID2, code2, sum(quantity) as tot2
> from rec2
> group by empID2, code2
> order by empID2,code2
> )
> select empid1, code1, tot1, tot2
> from sumRec1 left outer join sumRec2 on empid1=empid2 and code1=code2
> where tot1<>tot2
>
> <untested>
>
> Rob Berendt
>