盘点SQL语句 updatetable1settable1.column1=(selecttable2.column1fromtable2 where关联条件) whereexists(select1fromtable2 where关联条件);