> >Firebird doesn't support "derived tables" (that's what
> >you're doing, not a "subselect").
> >
> >Why not simply use:
> >
> >select count(*), user_name
> >from user
> >group by user_name
>
> Then he won't get the full count.
> Weird kinda output spec. I'm curious about what its use is...

Yeah, I noticed that afterwards. I only looked at the query first :-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com