选择具有左外连接问题的查询 [英] Select Query with left outer join problem

问题描述

我使用的是VS2010。数据库MSAccess2010。当我使用多个左外连接查询时，

我遇到麻烦。



我的查询

Hi, Iam using VS2010. DataBase-MSAccess2010. While I use the multiple Left Outer Join Query,
Iam facing trouble.

My Query

Select dc.*, it.itm_description, pt.pty_name 
from dcmst dc 
left outer join itemmst it on dc.itm_code = it.itm_code 
left outer join partymst pt on dc.del_pty_code = pt.pty_code

收到错误

OLEDB异常未处理

查询表达式'dc.itm_code中的语法错误（缺少运算符） = it.itm_code左外连接partymst pt on dc.del_pty_code = pt.pty_cod'。

真的我无法理解我的错误......有没有人可以指出我的错误..



感谢帮助

Receiving the error
OLEDB Exception was unhandled
Syntax error ( missing operator) in query expression 'dc.itm_code=it.itm_code left outer join partymst pt on dc.del_pty_code=pt.pty_cod'.
Really I can't understand my mistake...Does anybody can point my mistake..

Thanks for the helps

推荐答案

向犯了同样错误的人学习：multiple-left-joins-in-ms-access.html [ ^ ]

Learn from someone who made the same mistake: multiple-left-joins-in-ms-access.html[^]

作为彼得的答案你需要额外的一对括号，但你仍然会得到语法错误。

使用LEFT JOIN操作创建一个左外连接

As peter's answer you need additional pair(s) of parentheses but still you will get syntax error.
Use a LEFT JOIN operation to create a left outer join

Select dc.*, it.itm_description, pt.pty_name 
FROM (dcmst dc LEFT JOIN itemmst it on dc.itm_code = it.itm_code) LEFT JOIN partymst pt on dc.del_pty_code = pt.pty_code

这篇关于选择具有左外连接问题的查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！