Re: inline view vs. subquery

> SELECT field1
> FROM (
> SELECT field1, count(*)
> FROM sometable
> GROUP BY field1);

 AFAIK you have to provide a table alias for an inline-view; so the last line f.e. must be "GROUP BY field1) NAME;".

-- 
C++ is the only feasible way to write large C-programs