无法理解这个SQL查询语句有什么问题:
USE [My_db]
GO
SELECT ItemId
,Subject
,CreatedOn
FROM ItemBase AS e
INNER JOIN ItemExtensionBase AS p
ON e.ItemId = p.ItemId
GO
错误:
Msg 209, Level 16, State 1, Line 4
Ambiguous column name 'ItemId'.
ItemId
列在两个表中都存在。