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

W

Wisam-j

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.
 
O

Ofer Cohen

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A bug in GUI of creating query with more outer joins between two tables 5
INNER JOIN WITH 3 TABLES 2
Ambiguous outer join 9
Request for help with ambiguous outer join 1
Simulating A Full Outer Join in Access from 3 Tables 12
Outer Join more than two tables. Possible? 1
Access 2000 relationships and data entry/key fields 2
ambiguous outer join - how to include query in an sql statement 0

Top