以文本方式查看主题

-  Foxtable(狐表)  (http://www.foxtable.com/bbs/index.asp)
--  专家坐堂  (http://www.foxtable.com/bbs/list.asp?boardid=2)
----  请教，关键字 'LEFT' 附近有语法错误。  (http://www.foxtable.com/bbs/dispbbs.asp?boardid=2&id=172226)
--  作者：bluev
--  发布时间：2021/9/30 11:38:00
--  请教，关键字 'LEFT' 附近有语法错误。
错误提示：关键字 \'LEFT\' 附近有语法错误。
s elect " & _
“{表A}.ID " & _
",{表B}.类型 " & _
"from {表A}" & _
"LEFT JOIN {表B} ON {表A}.ID = {表B}.ID" & _
"WHERE {表B}.类型 =21"

这个SQL语句在 执行SQL功能里面完全可以执行，但在 SQLCommand 里面 就一直提示以上错误，请教下如何解决？？
--  作者：有点蓝
--  发布时间：2021/9/30 11:59:00
--  
完整代码发上来看看
--  作者：逛逛
--  发布时间：2021/9/30 12:05:00
--  
加上空格试试

“  s elect " & _
“  {表A}.ID " & _
"  ,{表B}.类型 " & _
"  from {表A}" & _
"  LEFT JOIN {表B} ON {表A}.ID = {表B}.ID" & _
"  WHERE {表B}.类型 =21"
--  作者：bluev
--  发布时间：2021/9/30 12:07:00
--  
Dim cmd As New SQLCommand
cmd.ConnectionName = ss
Dim dt As DataTable
Dim Cols1() As String = {"ID","TrType","InterID","EntryID","DDate","DeptID","EmpID","SupplyID"}
Dim Cols2() As String = {"ID","TrType","InterID","EntryID","DDate","DeptID","EmpID","SupplyID"}
Dim cmb As Winorm.ComboBox
MessageBox.Show("开始sql")
cmd.CommandText ="s elect" & _
"ID" & _
",{STOCK}.TranType" & _
",{STOCKM}.InterID" & _
",EntryID" & _
",{STOCK}.DDate" & _
",{STOCK}.DeptID" & _
",{STOCK}.EmpID" & _
",{STOCK}.SupplyID" & _
"From {STOCKM}" & _
"LEFT JOIN {STOCK} ON {STOCKM}.InterID = {STOCK}.InterID" & _
"WHERE {STOCK}.TranType = 2"
MessageBox.Show("结束SQL")
dt = cmd.ExecuteReader()
--  作者：有点蓝
--  发布时间：2021/9/30 13:43:00
--  
像3楼说的，加上空格再试试

弹出看实际的sql
MessageBox.Show(cmd.CommandText)
--  作者：bluev
--  发布时间：2021/9/30 14:34:00
--  
可以了，多谢！！