[ÇóÖú]¹ØÓÚ²åÈë¼Ç¼µÄÎÊÌâ

ö•©mÔ’

СµÜÓÐÒ»ÎÊÌâÅνâ¾ö£º
ÏÖÓÐÁ½¸ö±íT1£¨code,money£©¡¢T2(id,code,money)£¬Èç¹ûT1.CODE=T2.CODEÔòT1.MONEY=T1.MONEY+T2.MONEY,Èç¹ûT1.CODE<>T2.CODEÔòÔÚT1ÖвåÈëÒ»ÌõмǼ¡£ÀýÈç
T1±í T2±í
001 100.00 1 001 200.00
002 150.00 2 003 300.00
Ö´ÐкóµÄ½á¹ûΪ
T1±í
001 300.00
002 150.00
003 300.00
ÇëÎÊҪʵÏÖÕâ¸ö¹¦ÄÜASP´úÂ뾿¾¹ÒªÈçºÎд°¡£¿

ÔÆ-Æ®ÌìÑÄ

sql_select="select T2.code,T2.money from T2,T1 where T1.CODE<>T2.CODE"
Õâ¾ä²é²»µ½¶«Î÷°¡£¿ÏÔʾ..eof or bof..........

œ\Ë{äCd¨¥°®

...
sql_update="update T1,T2 set T1.MONEY=T1.MONEY+T2.MONEY where T1.CODE=T2.CODE"
conn.execute(sql_update)

sql_select="select T2.code,T2.money from T2,T1 where T1.CODE<>T2.CODE"
...
rs.open sql_select,conn,1,3
do while not rs.eof
sql_insert="insert into T1 (code,money) values ('"&rs(0)&"','"&rs(1)&"')"
conn.execute(sql_insert)
rs.movenext
loop
rs.close
set rs=nothing
conn.close
set conn=nothing