MySQL Inner Join - Unknown column on 子句

Question

我已经弄乱了 MySQL 一段时间，设置了所有数据库，现在我正在尝试使用 InnerJoin 将表连接在一起，但我一直收到这个“子句上的未知列”错误，尝试谷歌搜索但是我的代码似乎是正确的。

查询如下所示:

    select 
        CharacterName, ClassName, PerkName
    FROM 
        rpgcharacter
    INNER JOIN 
        class ON rpgcharacter.idClass = class.idClass
    inner join 
        perks on rpgcharacter.idRPGCharacter = perklist.idRPGCharacter; 

错误

Code: 1054. Unknown column 'perklist.idRPGCharacter' in 'on clause'

Answer 1

啊，我明白我做错了什么，显然因为我之前没有比较过甚至没有提到查询找不到表，这是我找到的解决方案。

select 
    rpgcharacter.CharacterName, class.ClassName,
    perks.PerkName, skills.SkillName
from 
    perklist
inner join 
    rpgcharacter on perklist.idRPGCharacter = rpgcharacter.idRPGCharacter
inner join 
    class on rpgcharacter.idClass = class.idClass
inner join 
    perks on perklist.idPerks = perks.idPerks
inner join 
    skilllist
inner join 
    skills on skilllist.idSkill = skills.idSkills 
           and skilllist.idRPGCharacter = rpgcharacter.idRPGCharacter
where 
    perklist.idRPGCharacter = 3