Syntax error

[Guest]

What is wrong with my syntax
In (SELECT [2DNdetail]![Deliv note detail ID]
FROM 2DNdetail INNER JOIN 4Shipdetail ON [2DNdetail]![Deliv note detail ID]
= [4Shipdetail]![Dilivery note Detail ID] )

 

[Van T. Dinh]

I had some problems with Table names starting with digit character before.

Try enclosing the Table names in square brackets like:

In (SELECT [2DNdetail].[Deliv note detail ID]
FROM [2DNdetail] INNER JOIN [4Shipdetail]
ON [2DNdetail].[Deliv note detail ID] = [4Shipdetail].[Dilivery note Detail
ID])