Subject Re: Newbie: SP isc_dsql_prepare failed
Author Bhavbhuti Nathwani
Hi Svein

--- In, Svein Erling Tysvær
<svein.erling.tysvaer@...> wrote:
> Don't know which Firebird version you are using, but try


> 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.