Search code examples
ms-accessinner-join

Inner join on 3 tables is not working

I have the following data tables (please find the attached Image). image I'm trying to execute a query using inner join on more than 2 tables. Following is my query, Please let me know where I'm doing the mistake. I am using MS-Access.

SELECT Employees.Namee,WeekDay.DayName,Schedule.StartTime,Schedule.Hours FROM Schedule  INNER JOIN Employees ON Schedule.Emp_ID = Employees.ID  INNER JOIN  WeekDay ON Schedule.Weekday = WeekDay.ID;
Solution

  • you need parentheses when you have multiple joins. Try this

    SELECT Employees.Namee,WeekDay.DayName,Schedule.StartTime,Schedule.Hours FROM
(Schedule  INNER JOIN Employees ON Schedule.Emp_ID = Employees.ID)  INNER JOIN  
 WeekDay ON Schedule.Weekday = WeekDay.ID;