[hy网络]业主信息查询sql

[landv]

SELECT
u.id,
u.nick_name AS `姓名`,
u.phone AS `电话`,
u.create_time AS `创建时间`,
u.wx_open_id AS `微信ID`,
u.sex AS `性别`,
a.relation_name AS `真实姓名`,
a.relation_address AS `地址`,
a.relation_tel AS `电话`,
a.areas AS `区域`,
d.city AS `城市`,
d.totalPrice AS `价格`,
d.houseRoom AS `户型`,
e.community_name AS `小区`,
e.building_number AS `门牌号`,
e.type AS `住户类型`
FROM
c_app_user AS u
LEFT JOIN c_app_user_address AS a ON u.id = a.user_id
LEFT JOIN c_app_user_demand AS d ON u.id = d.user_id
LEFT JOIN c_app_user_estate AS e ON u.id = e.user_id 




--业主信息
SELECT
i.id,
i.building_number AS `楼号`,
i.unit_number AS `单元`,
i.house_number AS `房号`,
i.owner_name AS `业主姓名`,
i.owner_phone AS `业主电话`,
c.community_name AS `小区名字`
FROM
c_community_info AS i
LEFT JOIN c_community AS c ON c.id = i.community_id