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

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