How to implement the outer join in ACCESS for more than 2 tables?

[Guest]

I have three tables (Employees, Outsourced and Projects).
Projects table include
project_id,
project_name,
emp_id as foreign key to Employees.id
and Outsourced _id as foreign key to Outsourced.id.

I need a query to show the project name, Employee_name, Outsourced name.
Kindly, to help me to generate the SQL Statement.

 

[Guest]

The SQL you can use

Select Projects.[project name], Employees.[Employee_name] ,
Outsourced.[Outsourced name] From (Projects Inner Join Employees On
Projects.emp_id = Employees.emp_id ) Inner Join Outsourced On
Projects.Outsourced _id = Outsourced.Outsourced _id

But you still need to know how to build queries, so try this link

http://www.databasedev.co.uk/query_joins.html