Joining multiple access database tables - Syntax error (missing operator) in query expression

Question

I am trying to join multiple tables from an access database. When I join two it works fine, but I need to join 9. Trying to join 3 like so gives the error:

Syntax error (missing operator) in query expression

Here is my command:

OleDbCommand gpInfoCommand = new OleDbCommand("SELECT * FROM GPInformation " +
                                              "LEFT JOIN GPAvailability ON GPInformation.ID=GPAvailability.GPID " +
                                              "LEFT JOIN GPCustomPayRates ON GPInformation.ID=GPCustomPayRates.GPID", connection);

score 1 · Accepted Answer · edited May 23 '17 at 12:22

1

MS Access requires parentheses around joins when there is more than one. See the examples here: Is it possible to do a 3 table join in MS-Access?

edited May 23 '17 at 12:22

Community

1
1

answered Mar 24 '15 at 18:48

Erik

5,355
25
39

score 1 · Answer 2 · answered Mar 24 '15 at 18:54

MS Access has an arcane syntax for multiple joins that requires parentheses:

SELECT *
FROM (GPInformation LEFT JOIN
      GPAvailability
      ON GPInformation.ID = GPAvailability.GPID
     ) LEFT JOIN
     GPCustomPayRates
     ON GPInformation.ID = GPCustomPayRates.GPID;

Joining multiple access database tables - Syntax error (missing operator) in query expression

2 Answers2