Chris,
> You'll have to GROUP BY nationality, total_members
Oops. Problem with posting untested SQL ...
> > > would this repeatedly execute the inner query over and over?
> >
> > No, it'd do it just once, because the sub-select has no dependency on
> > the outer select. (If the sub-select used any variables from the
That's great, Tom. Yet another place where we've surpassed MS SQL Server in
query implementation.
--
Josh Berkus
Aglio Database Solutions
San Francisco