I did, same error. I don't think I have a corrupt database, but I may have to
create a mini database to track this down. Can you write and test a 1 line
command that you know works on one of your data bases and email it to me?
TIA!
Mike Sinclair
Bill Downall wrote:
> Try it the other way around, with the aggregate function left of the equal
> sign in the Having clause. Also, be specific that you are grouping by the
> same patnumbr that you are SELECTING:
>
> ... GROUP BY t1.patnumbr +
> HAVING SUM (t2.netdue) = t1.balance
>
> Bill
>
> On Wed, 19 Sep 2001 21:15:41 +0000, MJS wrote:
>
> >SELECT T1.patnumbr FROM patinfo T1, baldue T2 WHERE
> T1.patnumbr =
> >T2.patnumbr GROUP BY patnumbr HAVING T1.balance = SUM
> (T2.netdue)
