给我的SQL语句挑挑刺!!!!
大家帮帮忙!帮我把这条语句完成!
我将万分感激!!!!!!11
Dim Cid As String
Dim Mid As String
Dim Pid As String
Dim begindate As String
Dim enddate As String
Cid = Text1.Text
Mid = Text2.Text
Pid = Text3.Text
begindate = Text4.Text
enddate = Text5.Text
strSQL = "SELECT 订单ID.客户ID, 订单ID.生产ID, 订单ID.产品ID, _
客户ID.客户名称, 订单ID.单价, 订单ID.数量, 订单 _
ID.总价,订单ID.订单日期 " & _
"INTO [客户信息] " & _
"FROM 订单ID INNER JOIN 客户ID " & _
"ON 订单ID.客户ID = 客户ID.客户ID" & _
"where 订单ID.客户ID=" & Cid & " and 订单ID.生产ID " & Mid & _
"and 订单ID.产品ID=" & Pid &_
"between 订单ID.开始日期=" & begindate _
& " and 订单ID.结束日期=" & enddate
我这条语句那里错了????我运行时它提示我操作符丢失!!!!!!!
谢谢!