Re: What's wrong with this syntax?

[Bill Downall]

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)