内部联接中缺少运算符的语法错误

Question

我提出了以下问题：

SELECT [tbl_Imp_tabel WBS WPE.Verantwrd], [tbl_Imp_tabel WBS WPE.WBS_Id], [tbl_Imp_tabel        WBS WPE.Koptekst], [tbl_Users.UserName], [tbl_Users.WPENaam]
FROM  [tbl_Imp_tabel WBS WPE]
INNER JOIN [tbl_Users]
ON tbl_Imp_tabel WBS WPE.Verantwrd = tbl_Users.WPENaam ;

但是，我的访问权限告诉我，我的线路上有一个丢失的接线员：

ON tbl_Imp_tabel WBS WPE.Verantwrd = tbl_Users.WPENaam ;

知道怎么解决这个问题吗？

提前感谢

Answer 1

在ON子句中，您忘记了表名tbl_Imp_tabel WBS WPE.Verantwrd前后的方括号。Usage of [ ] in SQL

SELECT [tbl_Imp_tabel WBS WPE.Verantwrd], [tbl_Imp_tabel WBS WPE.WBS_Id], [tbl_Imp_tabel        WBS WPE.Koptekst], [tbl_Users.UserName], [tbl_Users.WPENaam]
FROM  [tbl_Imp_tabel WBS WPE]
INNER JOIN [tbl_Users]
ON [tbl_Imp_tabel WBS WPE.Verantwrd] = tbl_Users.WPENaam ;

Answer 2

在ON子句中，ON子句中的表名周围有遗漏的方形barckets

尝尝这个

SELECT [tbl_Imp_tabel WBS WPE].[Verantwrd], [tbl_Imp_tabel WBS WPE].[WBS_Id], [tbl_Imp_tabel WBS WPE].[Koptekst], [tbl_Users.UserName], [tbl_Users.WPENaam]
FROM  [tbl_Imp_tabel WBS WPE]
INNER JOIN [tbl_Users]
ON [tbl_Imp_tabel WBS WPE].[Verantwrd] = tbl_Users.WPENaam ;