Subject Re: [firebird-support] SELECT COUNT(sub_select.*) as COUNT, sub_select.user_name ...
Author Martijn Tonies
> >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
Upscene Productions