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

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

瀏覽:339
日期:2026-04-21
Without the update-and-join notation (not all DBMS support that), use: UPDATE QuestionTrackings SET QuestionID = (SELECT QuestionID FROM AnswerTrackings WHERE AnswerTrackings.AnswerID = QuestionTrackings ......看更多