SQL UPDATE SET one column to be equal to a value in a related ...

update q set q.QuestionID = a.QuestionID from QuestionTrackings q inner join QuestionAnswers a on q.AnswerID = a.AnswerID where q.QuestionID is ...

www.google.com.tw