Syntax INSERT_RECORDSET destination-table ( list-of-fields ) SELECT list-of-fields1 FROM source-table [ WHERE where-clause ] [ JOIN list-of-fields2 FROM joined-source-table [ WHERE joined-where-clause ]]