I have the following code:
string sSelect = @"select a.nume, a.cui, b.suma, b.perioada, c.nume_produs from client as a
left join client_produs as b on a.id_client = b.id_client
left join produs as c on b.id_produs = c.id_produs";
con.Open();
OleDbCommand cSelect = new OleDbCommand(sSelect, con);
OleDbDataReader clientsInfo = cSelect.ExecuteReader();
The purpose of the above select statement is to retrieve all the information stored in the database.
The problem is I am getting an error : "System.Data.OleDb.OleDbException: 'Syntax error (missing operator) in query expression 'a.id_client = b.id_client left join produs as c on b.id_produs = c.id_produs'.'"
I cannot find the reason why and any help would be appreciated.