select a.user_name from user1 a join user1_skills b on b.user_id = a.id where b.skill in ('念经','变化','腾云','浮水',) and b.skill_level>0 group by a.user_name having couint(*)>=2 ;
转载于:https://my.oschina.net/u/3430557/blog/1029907
select a.user_name from user1 a join user1_skills b on b.user_id = a.id where b.skill in ('念经','变化','腾云','浮水',) and b.skill_level>0 group by a.user_name having couint(*)>=2 ;
转载于:https://my.oschina.net/u/3430557/blog/1029907