update A set A.XXX='XXXX'from TableA Ainner join TableB B on B.XX=A.XXwhere XXXXX 转载于:https://www.cnblogs.com/xcxcxcxc/p/5541213.html