SELECT c.name as cn,p.name as pn,ci.name as cin FROM aaa_countries as c LEFT JOIN aaa_province as p on c.id=p.pid LEFT JOIN aaa_city as ci on p.code=ci.provincecode
...全文
76回复打赏收藏
TP sql语句问题
我的3表省市联动 我想用tp的 JION()函数 自己写的不对 怎么转变 下面有代码 和截图 SELECT c.name as cn,p.name as pn,ci.name as cin FROM aaa_countries as c LEFT JOIN aaa_province as p on c.id=p.pid LEFT JOIN aaa_city as ci on p.code=ci.provincecode