Example 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;