首页上一页 1 下一页尾页 2 条记录 1/1页
vb问题请指教?
发表在VB答疑区
2006-07-26
是否精华
是
否
版块置顶:
是
否
adoAccount.RecordSource = "SELECT * FROM (SELECT units, SUM(addgathering) AS 应收增加, SUM(factaddfee) AS 实际增加,SUM(reducegathering) AS 应收减少, SUM(factfee) AS 实际减少 FROM (SELECT * FROM tbS_currentaccount WHERE (billdate BETWEEN & frm_addDate.DTPicker1.Value & AND & frm_addDate.DTPicker2.Value & )) DERIVEDTBL GROUP BY units) DERIVEDTBL WHERE (units = + frm_unitsList.adoCount.Recordset.Fields(0).Value + )"
中的“AS 应收增加”指的是什么?可以不加吗?
中的“AS 应收增加”指的是什么?可以不加吗?