摘要： update table_name set A.c1=B.c1,A.c2=B.c2... from table_name A,table_name B where A.id='45223' and B.id='154156132'update T608 set (c890020031,c890020032)= (select count(c800020019),'1' from t608 where c800020019='1363' ) where c800020019='136' 阅读全文