Answered in public.interbase.general...


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com

See you at the First European Firebird Conference in May in Fulda, Germany
http://www.firebird-conference.com

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