How do you do multiple joins to the same table?
Given an Address table that has both Billing and Shipping Addresses (2 records) for the same customer.
Trying the below but I get Join Expression not supported
FROM ( ( ( OrderDetail
INNER JOIN [Order] ON OrderDetail.OrderNumber = [Order].[Order Number] )
INNER JOIN Customer ON Customer.ID = [Order].BIllingId)
INNER JOIN Customer ON Customer.ID = [Order].ShippingId)