|Subject||Re: [firebird-support] SELECT COUNT(sub_select.*) as COUNT, sub_select.user_name ...|
> >Firebird doesn't support "derived tables" (that's whatYeah, I noticed that afterwards. I only looked at the query first :-)
> >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...
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL