Hi Marcelo,

Thank you for your help.
Unfortunately Your answer do do not work.

I have tried another solution that works:

Select Number from MyTable
where NumDoc NOT IN (Select NumDoc from MyTable
where (AnswerA = 'Yes') or
(AnswerB = 'Yes')));

Thank you very much for your kind attention.

Best regards,

Marcelo.

--- In ib-support@yahoogroups.com, Marcelo Pitanga
<marcelopitanga@h...> wrote:

> Hi Marcelo,
>
> Try
>
> Select Number from MyTable
> where NumDoc <> (Select DISTINCT NumDoc from MyTable
> where (AnswerA = 'Yes') or (AnswerB

= 'Yes'));

>
> Regards,
> Marcelo Pitanga
>
> > ----- Mensagem original -----
> > De: mcrosman1957 [SMTP:delphi7@b...]
> > Enviada em: quinta-feira, 24 de abril de 2003 10:55
> > Para: ib-support@yahoogroups.com
> > Assunto: [ib-support] Help: Multiple rows in singleton

select

> >
> > 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.
> >
> >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/

> >