Microsoft Dynamics Axapta Technical,Functional Coverage

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;