99999久久久久久亚洲,欧美人与禽猛交狂配,高清日韩av在线影院,一个人在线高清免费观看,啦啦啦在线视频免费观看www

熱線電話：13121318867

登錄

kejiayuan0806

2019-03-01 閱讀量: 877

sql查詢語句問題

問題描述：

有兩張表

tbl_user(uid,uname,province_id,city_id,area_id)
tbl_area(id,aname,pid)
其中province_id,city_id,area_id全部為tbl_area表的主鍵id
能不能通過一條sql語句查詢出如下結(jié)果

uid,uname,province_name,city_name,area_name
1, 張三, 河北, 衡水, 饒陽

解決方法：

SELECT u.uid, u.uname, p.aname AS province_name, c.aname AS city_name, a.aname AS area_name
FROM tbl_user AS u
LEFT JOIN tbl_area AS p ON p.id = u.province_id
LEFT JOIN tbl_area AS c ON c.id = u.city_id
LEFT JOIN tbl_area AS a ON a.id = u.area_id
LIMIT 100;