Update and Delete table with join condition:

UPDATE
UPDATE tblCalibrationReview
SET poNumber = tblCalibrationReview.[PONumber],
calCertNumber = tblCalibrationReview.[CalCertNumber],
q1Review = (CASE tblCalibrationReview.ReviewQ1 WHEN 'Yes' THEN 1
WHEN 'No' THEN 0 WHEN 'N/A' THEN 3 ELSE 3 END),
followUp = tblCalibrationReview.[Followup]
FROM CalibrationReview AS tblCalibrationReview
LEFT OUTER JOIN tblEquipments ON tblCalibrationReview.equipmentId = tblEquipments.ID
WHERE tblCalibrationReview.[EquipmentNumber] = tblEquipments.AssignedID
_____________________________________________________________________________


Update t1
set t1.DESCRIPTION = t3.DESCRIPTION
from TBL1 t1 inner join TBL2 t2
on t1.UNIQUE_ID = t2.UNIQUE_ID_2
inner join TBL1 t3
on t2.UNIQUE_ID_1 = t3.UNIQUE_ID
 
______________________________________________________________________________
 
DELETE
 
Delete data from table using left outer join
delete t1 FROM projects AS t1 LEFT OUTER JOIN emp_project AS t2 on t1.serial_no= t2.projectid where t1.serial_no=7
what is wrong with query
delete t1,t2 FROM projects AS t1 LEFT OUTER JOIN emp_project AS t2 on t1.serial_no= t2.projectid where t1.serial_no=13
Note:
Your delete statement is incorrect. You've to have two seperate delete statement.
Alternatively you can use Delete Cascade with proper relartionship between two tables
That's what I told you that you can not delete from two tables in single query unless you use delete cascade or have two seperate query