Hi,

I am using InterBase 6.0.2.

I have a table MyTable with the following fields:
Number, NumDoc, AnswerA and AnswerB.

I have tried to execute the following select instruction:

Select Number from MyTable
where NumDoc <> (Select NumDoc from MyTable
where (AnswerA = 'Yes') or (AnswerB = 'Yes'));

But I have get the error message "Multiple rows in singleton select"

How can I solve this problem ?

Problem.
=======
I have to select all Number values from the records in which NumDoc is
different from the NumDoc values of the records in which the AnswerA
or AnswerB values are equal to 'Yes'.

How can I do this select?

Thanks for any help.

Marcelo.