- Foxtable(狐表) (http://www.foxtable.com/bbs/index.asp)
-- 专家坐堂 (http://www.foxtable.com/bbs/list.asp?boardid=2)
---- Access 是否不支持二个left join (http://www.foxtable.com/bbs/dispbbs.asp?boardid=2&id=162089)
-- 发布时间：2021/4/5 18:35:00
-- Access 是否不支持二个left join
.NET Framework 版本：4.0.30319.1
Foxtable 版本：2020.5.29.8
错误所在事件：
详细错误信息：
语法错误 (操作符丢失) 在查询表达式 \'a.itid = x.pcid left join [产品工价表] As b on x.itid = b.itid\' 中。
代码如下：（left join 任何一句都可以，但两句就有问题。）
Dim tb As Table = Tables(e.Form.Name & "_" & "Table1")
Dim dt As DataTable = tb.DataTable
Dim cmd As new SQLCommand
cmd.C
cmd.CommandText = "sel ect x.* "
cmd.CommandText &= " from {进仓总表} as x "
cmd.CommandText &= " left join {生产计划表} As a on a.itid = x.pcid "
cmd.CommandText &= " left join {产品工价表} As b on x.itid = b.itid "
tb.DataSource = cmd.ExecuteReader
-- 发布时间：2021/4/5 19:38:00
--
此主题相关图片如下：222.jpg
-- 发布时间：2021/4/5 21:45:00
--
cmd.CommandText = "select x.* " from ({进仓总表} as x left join {生产计划表} As a on a.itid = x.pcid) left join {产品工价表} As b on x.itid = b.itid "