SQL - Insert Into Table Where Not Exists In Another Table

I am getting info from one table, CalibrationReview, that is not in
another table, tblEquipments.

SELECT EquipmentNumber, Model, SerialNumber, Make, CalLabName, CalDate
FROM CalibrationReview
WHERE NOT EXISTS (SELECT AssignedID FROM tblEquipments WHERE AssignedID = CalibrationReview.EquipmentNumber)

Now, I need to take these rows and INSERT them into tblEquipments,
but with some conditions.

tblEquipments has some contraints, so, the following needs to be done:

Using dbo.CalibrationReview.EquipmentNumber, get CalibrationMaster.TestTechnology where dbo.CalibrationReview.EquipmentNumber = dbo.CalibrationMaster.EquipmentID

Then take CalibrationMaster.TestTechnology and read tblTestTechnology.testTechnology and get tblTestTechnology.id

So,

tblEquipments.testTechnology = tblTestTechnology.id OR 1 if not found
WHERE dbo.CalibrationReview.EquipmentNumber = dbo.CalibrationMaster.EquipmentID and CalibrationMaster.TestTechnology = tblTestTechnology.testTechnology


And similar for CalibrationReview.CalLabName.

tblEquipments.calLab = tblLabs.ID where tblLabs.LabName = CalibrationReview.CalLabName

I hope this is clear as I can write this in code behind, but it's
much better using sql simply because it's faster and only needs to
be run once.

Inheriting databases and combining all of them to develop a large
.Net management system is fun, huh?


Thanks for any input,

Zath