Ambiguous outer joins

  • Thread starter Thread starter Stephen Glynn
  • Start date Start date
S

Stephen Glynn

This is one of my blind spots.

I've three tables: tblCustomer, tblOrder and tblOrderDetails.

I've joined tblCustomer and tblOrder on CustomerID and tblOrder and
tblOrderDetails on OrderID. One customer places many orders and one
order contains many OrderDetails.

How do I write a query that will show me all the customers, all the
orders they've placed, and the details of each order?

Steve
 
You want to click on the join properties, and select all
from tblCustomer and only those from tblOrder that match.
Then, select all from tblOrder and only those from
tblOrderDetails that match. That should take care of your
ambiguous outer joins message.
 
Back
Top