reply inline On 9/5/07, Olaf Stein <[EMAIL PROTECTED]> 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
