--- In ib-support@y..., "csswa" <csswa@y...> wrote:

> Helen, your procedure worked. Oddly, when I ALTERed back to mine,
> that now works too. I can only think that altering the procedure
> fixed it. If I run into this prob again, I'll try the ALTER

first...

Andrew, your variant tries to compare 'Y' with Null when record for
current table is'nt presented in the flag table. It should'nt work
properly in this case regardless of Alter, seems you checked it
second time on another data. Helen's is correct.

Best regards, Alexander V.Nevsky.