Ed,

> Thank you for your respohse. I have not seen Coalesce before.

It will become your best friend very quickly

> Firebird 1.5 balks at the "Select" in the 3rd line "Token unknown, line 3, char
> 5."
>
> > SELECT
> > COALESCE( PI.Balance,0) + COALESCE(
> > SELECT(PAI.Balance) FROM PersonActInfo PAI where PAI.Person_ID
> ^^^^^^

My typo... the SELECT line needs to be in parentheses ... (SELECT(PAI.Balance) FROM PersonActInfo PAI where PAI.Person_ID)


Sean