Syntax error missing operator on inner join

Question

I have made the following query :

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 ;

Howver, my access tells me that i have a missing operator on the line :

ON tbl_Imp_tabel WBS WPE.Verantwrd = tbl_Users.WPENaam ;

Any idea how to solve this ?

Thanks in advance

Answer 1

You have missed square barckets around table name in ON clause

Try this

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

You have forgotten square brackets around table name [tbl_Imp_tabel WBS WPE.Verantwrd] in ON clause. 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 ;