SQL UPDATE SET one column to be equal to a value in a related table referenced by a different column

Without the update-and-join notation (not all DBMS support that), use: UPDATE QuestionTrackings SET QuestionID = (SELECT QuestionID FROM AnswerTrackings WHERE AnswerTrackings.AnswerID = QuestionTrackings ...

stackoverflow.com