Sql query in MS Access producing Syntax error

Question

I'm having trouble with a query in MSAccess. The code is shown below:

SELECT CustomerId, FirstName, Surname, DateOfBirth, WorkoutId, Name, Description
   FROM Customer 
   INNER JOIN (Registration INNER JOIN TrainingProgram (INNER JOIN WorkOutPlan)) 
   ON Customer.CustomerId = Registration.CustomerId 
   ON Registration.CustomerId = TrainingProgram.CustomerId 
   ON TrainingProgram.WorkId = WorkOutPlan.WorkId
      WHERE DateOfBirth > #01/01/83#;

The database has been created for a fictional gym.

The aim of the query is to show what workout plan members are on with a date of birth greater that 01/01/83. The information the query is selecting is coming from 3 Tables. Customer, TrainingProgram and WorkOutPlan. The other table 'Registration' links the Customer Table and Training Program table with 'CustomerId'

The query is producing a syntax error and highlighting the bracket '"("INNER JOIN WorkOutPlan))'. I cant see any issues with the code but maybe I have made a mistake along the way?

Your help would be much appreciated.

RichardTheKiwi · Accepted Answer · 2013-04-24 10:15:08Z

3

Bracket properly

SELECT CustomerId, FirstName, Surname, DateOfBirth, WorkoutId, Name, Description
FROM (Customer 
INNER JOIN (Registration
            INNER JOIN (TrainingProgram
                        INNER JOIN WorkOutPlan 
                                   ON Customer.CustomerId = Registration.CustomerId )
                        ON Registration.CustomerId = TrainingProgram.CustomerId )
            ON TrainingProgram.WorkId = WorkOutPlan.WorkId)
WHERE DateOfBirth > #01/01/83#;

answered Apr 24, 2013 at 10:15

RichardTheKiwi

108k28 gold badges206 silver badges269 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nick O'Hare Over a year ago

Thank you for your reply! I really appreciate it! I'm still receiving a Syntax Error. Its saying its in the Join Operation and highlighting just customer from -> 'SELECT "Customer"Id,' . Iv played around with it a bit but again cant seem to find any problems

Collectives™ on Stack Overflow

Sql query in MS Access producing Syntax error

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related