>Naomi,
>
>>No, doesn't work with HAVING clause.
>
>Just in case, I would point out you have a spelling mistake in your having clause
>
>>>SELECT ... ;
>>>, MAX(Trans.yReferral_balance_amount)
yReferral_balance_amount;
>>>...
>>>GROUP BY 1;
>> having yCurrent_balance_amount <>
yRefferal_Balance_amount - nvl(yTotalPayments,0)
>>>into cursor curBalances
Should I give you the stars then? <g>
Thanks a lot, Hugo, it worked. Now I'm ashamed <g> I'm supposed to be a good speller. But I always mix referral f and r.
If it's not broken, fix it until it is.
My Blog