>What would be the easiest way to add records from a view (Temporary table) to another view (permanent table). Both have the same fields.

INSERT INTO dbf_name [(FieldName1 [, FieldName2, ...])]

   SELECT SELECTClauses [UNION UnionClause SELECT SELECTClauses ...]