您需要加入
table2
UPDATe t1SET t1.ValidSince = t2.ValidSinceFrom Table1 t1Join Table2 t2 on t1.PKCol = t2.PKColWHERe t1.ID = '5C954C6F-FFD7-454A-9E2B-000076523819'

您需要加入
table2
UPDATe t1SET t1.ValidSince = t2.ValidSinceFrom Table1 t1Join Table2 t2 on t1.PKCol = t2.PKColWHERe t1.ID = '5C954C6F-FFD7-454A-9E2B-000076523819'