Also, "sum(nvl(npayment,0))" is probably better as "Nvl(sum(npayment),0)"
David Aldridge, "The Oracle Sponge" Senior Manager, Business Intelligence Development XM Satellite Radio Washington, DC Oracle ACE
Forum Rules
Reply With Quote