Error "Invalid use of '.', '!', or '()'. in query expression" returned when adding columns from multiple tables from Microsoft Database Files(.mdb) into one TIBCO Spotfire data table

Error "Invalid use of '.', '!', or '()'. in query expression" returned when adding columns from multiple tables from Microsoft Database Files(.mdb) into one TIBCO Spotfire data table

When loading data from .mdb file and trying to add all the columns from two different tables into one table using an inner join like the following query: 

The reason the above query was failing was because single quotation marks are used to represent the column name. To resolve, update the query to use the backtick(`) instead of the single quotation(') when referring to the table or column name. Doc: How to Import Data from OLEDB data source

• https://docs.tibco.com/pub/sfire-analyst/10.3.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/load/load_details_on_configure_data_source_connection_oledb.htm?rhhlterm=access&rhsyns=%20