Re: question : select

From: Phil Turgeon <phitur_at_hotmail.com>
Date: Mon, 12 May 2003 20:50:15 GMT
Message-ID: <Xns9379AB2A2875Aphiturhotmailcom@205.237.233.52>

"delaigue" <pascal.delaigue_at_wanadoo.fr> wrote in news:b9hctk$h6b$2_at_news-reader12.wanadoo.fr:

Bonjour pascal dans ta deuxieme requete la sous-requete peut retourner plusieurs rangées alors que le signe = doit en recevoir une seule (puisque demandid n'est pas une clé unique) Philippe

>
> this request does not work ( makes TOADD run out ) :
> select numdossier from dossier
> where dossierid = ( select ftdossierid from demande where demandeid =
> '165420327' )

demandeid is not a primary key so you could get multiple rows. Try IN instead of = Received on Mon May 12 2003 - 15:50:15 CDT