Dan,

>So, when I wrote the SQL for a summary view in the View builder it created this:

The view designer is semi-braindead when it comes to 3 or more tables. Just put one line of code above your select and store it in a prg

create sqlview MyView as ;
> SELECT field1, ...;
> FROM A;
> LEFT OUTER JOIN B;
> ON A.field1=B.field1;
> LEFT OUTER JOIN C;
> ON A.field1=C.field1;
> GROUP BY A.field1