Hello
Newbie and first time poster.
I am attempting an Inner Join on the
SalesLT.Product table and the
SalesLT.ProductCategory table
SELECT
Name AS ProductName
,Name AS CategoryName
FROM
SalesLT.Product AS p
INNER JOIN SalesLT.ProductCategory AS pc
ON p.ProductCategoryID=pc.ProductCategoryID
SELECT
[Name]
,[Name]
FROM
SalesLT.Product AS p
INNER JOIN SalesLT.ProductCategory AS pc
ON p.ProductCategoryID=pc.[ProductCategoryID]
SSMS indicates that the join is correct (no red underscores)
I get the following error message even though I have given the two fields a different alias
Msg 209, Level 16, State 1, Line 2
Ambiguous column name 'Name'.
Msg 209, Level 16, State 1, Line 3
Ambiguous column name 'Name'.
What am I doing wrong
Many thanks in advance
Charlie