Hi Svein

--- In firebird-support@yahoogroups.com, Svein Erling Tysvær
<svein.erling.tysvaer@...> wrote:

>
> Don't know which Firebird version you are using, but try

FB2

> Firebird 1.5 or earlier (I don't know about Fb 2.0) may put

NarrAcctOpBal2 first in the plan, which will of course fail, hence the
need to use LEFT JOIN.

Yes that was the case, I can now get a list of the accounts with the
return value from the SP.

Thanks a lot for your response.


Regards
Bhavbhuti