数据库中的GROUP BY问题
caodz 2001-10-29 10:30:55 Dim n As Integer 'EXCEL中行号
Dim sb As ADODB.Recordset
Dim strCnn As String
strCnn = "Provider=OraOLEDB.Oracle.1;Password=fx1234;Persist Security Info=True;User ID=fx;Data Source=cbsdb"
Set sb = New ADODB.Recordset
sb.CursorType = adOpenStatic
sb.Open "SELECT books.bno,books.bname,entries_mx.price,sum(entries_mx.amount) from books ,entries_mx w
here books.bsno=entries_mx.bsno and books.category2='文泉'
group by books.bno,entries_mx.price ", strCnn, , , adCmdText
一直报不是group by 表达式,那位给我解决一下