INSERTAR EN UNA TABLA REGISTROS QUE NO ESTÁN EN OTRA TABLA

insert into PK.CD_COMPLETION2 (KEY_ID,WELL_ID, WELLBORE_ID,COMPLETION_ID,COMPLETION_NAME )
Select T1.COMPLETION_ID,T1.WELL_ID,T1.WELLBORE_ID,T1.COMPLETION_ID,T1.COMPLETION_NAME
From CD_COMPLETION  T1
Left Outer Join
       PK.CD_COMPLETION2  T2
ON   T1.COMPLETION_ID = T2.COMPLETION_ID
where T2.COMPLETION_ID is null