SQL same exposed names
Hi
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])
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])
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Jim
Thanks for the grade. Good luck with your project. -Jim
ASKER
Thanks Jim
I think you have used Orders after inner join
INNER JOIN [Orders] ON ([Customers].[ID] = [Orders].[Customer ID]), [Orders]
is causing error
Please recheck it