inner join 是自关联, 请问你的是在一张表里吗? 如果不是的话, select .....from A join B on A.XX=B.XX join C on A.XX=C.XX where .....;