Ambiguous outer joins

[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

 

[Les]

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.