Inserting Multiple Records from One Database to Another

These are the following two tables I have:

UnitMaterial:
UnitId
MaterialId
InUnit
Training
Approval

PendingUnitMaterial
UnitId
MaterialId
InUnit

I have the following records in my PendingUnitMaterial Table:
1, 5, 0
2, 5, 1
3, 5, 1

I want to get these multiple records and insert them into my UnitMaterial Table but do not know how. I have looked at other places but the syntax is screwing me up. Any help would be greatly appreciated. Thanks

The easy way is to query pendingUnitMaterial, and then loop over than and insert each one into the unitMaterial table.

I have tried doing that and I get this error:

Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'VALUES'.

Here is my code:

<cfoutput>
<cfquery name="UnitMaterial" datasource="****">
SELECT *
FROM pendingunitmaterialView
</cfquery>

<cfloop query="UnitMaterial">
<cfquery name="insertUnitMaterials" datasource="****">
INSERT INTO dbo.unitmaterialView (
UnitId,
MaterialId,
InUnit,
FacilityApproval,
RaApproval
VALUES (
#UnitMaterial.UnitId#,
#UnitMaterial.MaterialId#,
#UnitMaterial.InUnit#,
1,
1
)
</cfquery>
</cfloop>
</cfoutput>

uh, you need a closing parenthesis after the last column name.

Oh wow I cant believe I didnt catch that. Sorry for the carelessness and thank you so much!