Example of insert recordset in to table using axaptaExample of insert recordset in to table using axapta

syntax of insert recordset is

insert_recordset DestinationTable ( ListOfFields )

select ListOfFields1 from SourceTable [ where WhereClause ]

[ join ListOfFields2 from JoinedSourceTable

[ where JoinedWhereClause ]]

example of insert recordset is

insert_recordset TableName (field1, field2)
    select field1, field2 
        from table2 
                where abc<= 1000;