SQL 未解析的对象到对象.对象不存在或引用不明确

Question

我正在尝试创建一个带有内部连接的视图：

CREATE VIEW [dbo].[MatchingTeamNames]
AS SELECT  [XMLSoccer-Team].[ID] AS SoccerID, [XMLSoccer-Team].[Name] AS SoccerName,
            [Smarkets-Team].[ID] AS SmarketsID, [Smarkets-Team].[Name]
FROM [XMLSoccer-Team], [MatchingTeamIDs], [Smarkets-Team]
INNER JOIN [MatchingTeamIDs] ON [MatchingTeamIDs].[XMLSoccerID] = [XMLSoccer-Team].[ID]

我收到内部连接的最后一部分的错误：[XMLSoccer-Team].[ID]

SQL 未解析的对象到对象。对象不存在或引用不明确

有什么想法我哪里出错了吗？

谢谢。

Answer 1

这是什么？ 隐式和显式连接语法在一起？永远不要这样做！

尝试使用显式联接语法进行此查询：

CREATE VIEW [dbo].[MatchingTeamNames]
AS SELECT  [XMLSoccer-Team].[ID] AS SoccerID, [XMLSoccer-Team].[Name] AS SoccerName,
            [Smarkets-Team].[ID] AS SmarketsID, [Smarkets-Team].[Name]
FROM [XMLSoccer-Team]
INNER JOIN [MatchingTeamIDs]
 ON [MatchingTeamIDs].[XMLSoccerID] = [XMLSoccer-Team].[ID]
INNER JOIN  [Smarkets-Team]
 ON (The Relations between this tables Smarkets-Team and the table its connected to)