SQL same exposed names
Posted on 2014-08-20
I get the following error when trying to run the SQL below. I am not sure what this means:
The objects "Orders" and "Orders" in the FROM clause have the same exposed names. Use correlation names to distinguish them.
SELECT [Orders].[Order ID], [Order Details].[Quantity], [Orders].[Customer ID], [Customers].[First Name], [Customers].[Last Name] FROM [Customers] INNER JOIN [Orders] ON ([Customers].[ID] = [Orders].[Customer ID]), [Orders] INNER JOIN [Order Details] ON ([Orders].[Order ID] = [Order Details].[Order ID])