您当前的位置： 首页 > 学无止境 > 心得笔记 网站首页心得笔记

多表连查-按地理位置距离进行排序

发布时间：2016-11-20 14:05:40编辑：雪饮阅读（）

 多表连查并按距离排序

select x1,y1,a.id,SQRT((x1*x1)+(y1*y1))-1 as juli ,b.name as gz,c.name as zn,d.name as gzi from ims_xm_housekeep_guzhuxinxi as a left join ims_xm_housekeep_gongzhong as b on a.fwgz=b.id left join ims_xm_housekeep_zhineng as c on a.sxzn=c.id left join ims_xm_housekeep_cankaogongzi as d on a.ckgz=d.id order by juli desc limit 0,4;
注意：
SQRT((x1*x1)+(y1*y1))-1中x1与y1代表第一个点的经纬度，“1”代表第二个经纬度的平方和