MySQL开发技巧（三）3-3 [MySQL] 使用关联方式实现多属性查询（一）

select a.user_name,b.skill,c.skill,d.skill from user1 a join user1_skills
b on a.id =b.user_id and b.skill='念经' join user1_skills c on c.user_id=b.user_id and c.skill='变化' join user1_skills d on d.user_id =c.user_id and d.skill=‘腾云’ where b.skill_level>0 and c.skill_level>0 and d.skill_level>0;

转载于:https://my.oschina.net/u/3430557/blog/1023590