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'
posted on 2011-04-21 10:41  appleying  阅读(270)  评论(1编辑  收藏  举报