Thank you.

Best regards,

Marcelo.

--- In ib-support@yahoogroups.com, "Martijn Tonies" <m.tonies@u...>
wrote:

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