sarcmission : id name car_id . . . sarcmissiontable : id mission_id .
I've tried this : UPDATE sarcmissiontable SET sarcmissiontable_1.car_id = sarcmission.car_id FROM sarcmissiontable AS sarcmissiontable_1 INNER JOIN sarcmission ON sarcmissiontable_1.mission_id = sarcmission.id
UPDATE sarcmissiontable SET sarcmissiontable.car_id = (SELECT sarcmission.car_id FROM sarcmission WHERE sarcmissiontable.mission_id = sarcmission.id)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)