Hi all.....
I can't seem to get this to work. I get an error message that says
-ERROR- Illegal column specification (2512)
SELECT T1.patnumbr FROM patinfo T1, baldue T2 WHERE T1.patnumbr =
T2.patnumbr GROUP BY patnumbr HAVING T1.balance = SUM(T2.netdue)
If I change it to something silly like this......
SELECT T1.patnumbr FROM patinfo T1, baldue T2 WHERE T1.patnumbr =
T2.patnumbr GROUP BY patnumbr HAVING 1=1
it does not give me any error message. I assume the error is after the word
HAVING, but I can't make it work!
The columns in T1(called patinfo) are patnumbr (real), balance (currency)
The columns in T2 (called baldue) are patnumbr (real), netdue (currency)
Any ideas?
TIA!
Mike Sinclair
