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@...]
> 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/
>