UPDATE b
SET b.Address = a.ADDRESS ,
b.lot = a.lot ,
b.lat = a.lat
FROM VisitPharmacy_StoreLocation a
LEFT JOIN Pharmacy b ON a.PharmacyID = b.PharmacyID
sql update left join
最新推荐文章于 2023-03-17 16:57:33 发布
UPDATE b
SET b.Address = a.ADDRESS ,
b.lot = a.lot ,
b.lat = a.lat
FROM VisitPharmacy_StoreLocation a
LEFT JOIN Pharmacy b ON a.PharmacyID = b.PharmacyID