sql连接3个表的问题
query = "select 'dingdan.客户',sum(dinghuo.金额),huikuan.回款时间 from dingdan " & _
"inner join dinghuo on dingdan.编号 = dinghuo.编号 inner join huikuan " & _
"on dingdan.编号 = huikuan.定单号 "
rs.CursorLocation = adUseClient
rs.Open query, Conn, adOpenDynamic, adLockOptimistic
出错提示:语法错误在:dinghuo on dingdan.编号 = dinghuo.编号 inner join huikuan " & _
"on dingdan.编号 = huikuan.定单号