Inserting into a table from values of query

[Tempora Telora]

So run a query that returns to me all values of balance and reps_id.
I then try and do the insert command but it doesnt like my values for my columns.

Examples
Select max(sum), rep from customer;
Insert into tempH values (sum, rep);

[Mark Spritzler]

When you do max(sum) the resulting field in the query is not called sum, you would have to give it an alias to give it a readable name to use in your insert

so max(sum) sum_total;

then in the values(sum_total, rep); And the values have to be in order of the fields in the temph table, plus only those two fields. If there are more than those two fields, than you need to include a fields() in your insert just before values()

Mark