SQL两表之间：根据⼀个表的字段更新另⼀个表的字段1. 写法轻松，更新效率⾼：update table1set field1=table2.field1,field2=table2.field2from table2where table1.id=table2.idupdate chq_gx_empinfo  setdeptzz = chq_gx_empinfo2.deptzz,dept...