Re: Need help with monstrous query migrated from sql server

> I suspect what you said should have been followed by a smiley-face

Definitely! :)

> but my question related to the OP's data only.

I could not determine what kind of data the OP had as I have absolutely no idea what kind of data is stored in the hboksaldo column. If that column contains only non-negative numbers, then the SUM will be positive. Either the column names are cryptic or shorthand in another language. I know that 'saldo' in Spanish is 'balance', it depending on the app, it is possible to have a negative balance. But then I'm only guessing! :)

Cheers,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown