Syntax error in FROM clause, what could be the reason?

Question

SQL

When querying in Access 2016, I see a "Syntax error in FROM clause" message. Here is the query:
SELECT Table1.indexObject, Table1.ObjectNames, table2.measureCommFromTab, table3.izmerenije, max(table3.datetimeMess)
FROM Table1, table2, table3
ON (table2.keyID = table3.measureComm_id) and (Table1.keyID = table3 .indexObjectsTab_id)
WHERE table2.keyID>0 And indexObject In (55296, 55226)
GROUP BY table2.measureCommFromTab, Table1.indexObject
ORDER BY Table1.indexObject
What could be wrong? There are nuances when using Access? The matter is that the same request, in SQLite normally works...
Perhaps it is necessary to register Join?

Answer 1

https://support.office.com/en-us/article/%D0%9E%D0...

Answer 2

conditions listed after ON move to the block after WHERE , you get

SELECT Table1.indexObject, Table1.ObjectNames, table2.measureCommFromTab, table3.izmerenije, max(table3.datetimeMess)
FROM Table1, table2, table3
WHERE   (table2.keyID = table3.measureComm_id) and (Table1.keyID = table3.indexObjectsTab_id) and
table2.keyID>0 And indexObject In (55296, 55226)
GROUP BY table2.measureCommFromTab, Table1.indexObject
ORDER BY Table1.indexObject

if joining tables is specified not through JOIN , but by enumeration after FROM ,
then the ON clause is not applied, and the join conditions are listed along with the record filtering conditions in the WHERE clause.

Answer 3

JOIN