写法:
UPDATE Document,
ObservationRequest
SET Document.CreateOrganizationName = ObservationRequest.OrganizationName
WHERE
Document.BusinessID = ObservationRequest.ObservationUID;
验证:
SELECT
o.ServiceSectID,
d.Modality
FROM
ObservationRequest o
INNER JOIN Document d ON o.ObservationUID = d.BusinessID
WHERE o.ObservationUID <> d.BusinessID;
mysql用一个表更新另一个表
标签:join modal uid oda sql inner sele 验证 date
本条技术文章来源于互联网,如果无意侵犯您的权益请点击此处反馈版权投诉
本文系统来源:http://www.cnblogs.com/llcdbk/p/7800093.html