MYSQL 双表联查,通过A表数组查询B表、C表对应的数据
我现在要查询A表中的id,userid,cname,areanid其中areanid和B表中的areaname对应 A表的cityid 和C表的cityname对应
解决方法:
select a.id,a.userid,a.cname,c.cityname,a.areaid GROUP_CONCAT(b.areaname) (与GROUP_CONCAT(b.areaname)字段相同) from `area` as b left join `member` as a on find_in_set(b.areaid,a.areaid) left join `city_dl` as c on c.cityid=a.cityid where a.areaid!='' GROUP BY(a.id) ORDER BY a.id
查询出的结果