Roy,

<< Even if that worked wouldn't it just give the number of rows in the
subquery? >>

Yes. If I understood Dieter correctly, that's what he wants.

Ole Willy Tuv

Roy,

PREPARE STMT FROM 'select count(*)
from
( select count(Zahl)AS Anzahl
  from Total
  where Zahl = '+cast (erste as varchar)+' or zahl ='+cast(zweite as varchar)+'
  group by Runde
  having count(Zahl) > 1
) as t';



Dieter









Roy Lambert <roy.lambert@skynet.co.uk> wrote:

Dieter


What was the final sql?

Roy Lambert

Ole


Re-reading you're right, I was wrong.

Roy Lambert

Dieter,

<< Now I get the error: Error #700 ....Invalid expression ? found , dynamic
parameter references not allowed..... >>

I'll double-check on this and see why this is.  I think it has to do with
the fact that we're using temporary views for implementing derived tables,
and currently we don't have parameter support available for the views.  Your
workaround is fine, of course.

--
Tim Young
Elevate Software
www.elevatesoft.com