I am trying to create a view with columns that are the result of a sum statement. For instance, when I add the code:
SELECT STATE, SUM(child_count) as Total_Children
group by STATE;
The Total_Children column does not auto_populate the column name or data type when I choose to "update_columns".
the column names come back as column_n and the datatype comes back as "unknown".
How do I make this work correctly so that I do not have to manually rekey every column?
Customer support service by UserEcho