'"Join expression not supported" for multiple Left Join in MS Access

I have the following query which I am passing as a string in my ASP.NET project: 

SELECT creditorName, amount, interestRate, interestType, interestCalculationMethod, insertedDate, o.fullName AS owner, u.fullName AS dataInsertedBy FROM ((tbl_savings s) LEFT JOIN tbl_users o ON (ownerID = o.userID)) LEFT JOIN tbl_users u ON (dataEnteredByID = u.userID);

for which I am getting the following error: 

+       $exception  {"Join expression not supported."}  System.Data.OleDb.OleDbException

I am using MS Access 2016 as the database.

What's wrong?

sqlms-accessoledb


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions