Two left join

  • Thread starter Thread starter Man Utd
  • Start date Start date
M

Man Utd

How do I do two left join:

Select *
From Order
Left Join Emp.ID on Emp.ID = Order.StaffID
Left Join OrderDetails on OrderDetails.OrderID = Order.ID

It seems the second Left Join is not supported.
 
See reply to your previous thread.

Please do not create multiple threads on the same question.
 
You must log in or register to reply here.

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

Forcing an ambiguous outer join 5
ambiguous outer joins 1
Nested JOIN clauses - order of precedence (Access 2007) 2
have query based from a left join, now need to exclude records.... 3
how do I put these 2 queries into 1 ?? 2
Updateable querie 2
Left Join query not working in Access 2010 0
Query works until sort is added 3

Back
Top