select max(name),sum(bal) from a where name="a"name需要聚集!!!dim adorecordset as new adodb.recordset
dim cn as new adodb.connection
cn.open "...."
adorecordset.open "select max(name),sum(bal) from a where name='a'",cn
set datagrid1.datasource = adorecordset
dim cn as new adodb.connection
cn.open "...."
adorecordset.open "select max(name),sum(bal) from a where name='a'",cn
set datagrid1.datasource = adorecordset
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货