At 11:26 AM 18/02/2006, Chris Voronin wrote:

>Isnt it DISTINCTCOUNT not COUNT(DISTINCT ....)?
>Don't remember the syntax off top of my head though.

There's no such thing in standard SQL.

./hb