mysql - 是什么原因导致 #1066 - 不唯一的表/别名以及如何修复它？

Question

这是 SQL 查询:

SELECT
    `cards.ID` AS ID,
    `cards.SetName` AS SetName,
    `variations.varCARDID` AS varCARDID,
    `variations.varID` AS varID,
    `collections.have` AS have,
    `variations.varTTP` AS varTTP,
    `variations.varPOP` AS varPOP,
    `collections.userID` AS userID,
    `collections.relID` AS relID
FROM
    `cards` AS C,
    `variations` AS V,
    `collections` AS Co
JOIN
    C
ON
    `cards.ID` = `variations.varCARDID`
JOIN
    V
ON
    `variations.varID` = `collections.relID`
WHERE
    `cards.SetName` = 'Ancient Origins' AND `collections.userID` = 2

这是表结构

table 卡:

• 身份证
• 设置名称

表格变化:

• varCARDID
• 变量ID
• varTTP
• varPOP

表集合:

• 有
• 用户ID
• relID

我想要实现的目标:

特定用户拥有的特定集合的卡牌(及其变体)列表。

我根据这里 (stackoverflow) 的大约 6 篇文章更改了我的原始代码，并得到了相同的结果。

预先感谢您的帮助。

编辑

这是我在尝试修复它之前开始使用的原始代码:

SELECT
    cards.ID AS ID,
    cards.SetName AS SetName,
    variations.varCARDID AS varCARDID,
    variations.varID AS varID,
    collections.have AS have,
    variations.varTTP AS varTTP,
    variations.varPOP AS varPOP,
    collections.userID AS userID,
    collections.relID AS relID
FROM
    cards,
    variations,
    collections
JOIN
    cards
ON
    cards.ID = variations.varCARDID
JOIN
    variations
ON
    variations.varID = collections.relID
WHERE
    cards.SetName = 'Ancient Origins' AND collections.userID = 2

Answer 1

选择...从卡c在 v.Varcardid = c.id 上加入变体 v加入 co.id = v.varid 上的收藏 co哪里...