数据库中的GROUP BY问题

[caodz]

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 表达式，那位给我解决一下

[caodz]

低层使用ORACLE数据库

[baoxiang]

sb.Open "SELECT books.bno,books.bname,entries_mx.price,sum(entries_mx.amount) from books ,entries_mx where books.bsno=entries_mx.bsno and books.category2='文泉' ｇｒｏｕｐ by books.bno,books.bname,entries_mx.price ", strCnn, , , adCmdText
改成这样试试。
现在ｕｐ没法用半角，你自己换一下吧。
斑竹写出ｂｕｇ来了

[caodz]

谢谢包香，刚才我也试出来了，不过分还得给您，您知道怎样给分吗？