SQlite使用不同的“on”语句连接两次相同的表

I couldn't find answer for my question, and I don't know if my query is correct and this could be a SQLite issue, please help me solve the problem.I couldn't find answer for my question, and I d