Re: sub-select with aggregate

> The other forms only move the filtering clauses around. There's
> still only a filter on the outer group_id equaling the inner
> group_id and a filter on group_id=3. It's just a question of
> whether it's:
>
> Scan users in subselect from group_id=3, group and aggregate them
> and join with users on subselect's group_id = users.group_id
>
> or
>
> Scan users for group_id=3, scan users in subselect, group and
> aggregate them and join these two on subselect's
> group_id=users.group_id.
>
> The latter is effectively what your original query gave, the former
> appears to be what my two queries from a couple of mails ago gives.

I'm sorry, if you misunderstood me - I didn't show it clear.
I want to scan users for group_id=3 and then join subselect for the same
group_id. I can't pass group_id=3 directly to subselect, because it's not a
query but a view.

--
Tomasz Myrta <jasiek(at)klaster(dot)net>