PHWinfo - Afficher un message

05/09/2007, 14h57

reply inline

On 9/5/07, Olaf Stein <steino@ccri.net> wrote:
>
> delete from geno_260k where ident=(select ident from geno_260k where a1=0
> group by ident having count(a1)>250000);

When a sub query returns more than one row in a where clause, then "="
should be replaced by the "in" .

--
Thanks
Alex
http://alexlurthu.wordpress.com

05/09/2007, 14h57	#4
Alex Arul Lurthu Messages: n/a Hébergeur:	Re: Delete query question reply inline On 9/5/07, Olaf Stein <steino@ccri.net> wrote: > > delete from geno_260k where ident=(select ident from geno_260k where a1=0 > group by ident having count(a1)>250000); When a sub query returns more than one row in a where clause, then "=" should be replaced by the "in" . -- Thanks Alex http://alexlurthu.wordpress.com