SELECT BDCDYH_S, zd_shangyq.ZL FROM (SELECT substring(person_real_estate.BDCDYH, 1, 19) as BDCDYH_S FROM `person_real_estate` where id_card = 110101199003070273) sub LEFT JOIN zd_shangyq on sub.BDCDYH_S=zd_shangyq.zddm;

select * from district_school where ZL="名下村";



SELECT substring(BDCDYH, 1, 19) , id_card FROM `person_real_estate`;

SELECT zd_shangyq.ZL,zddm FROM zd_shangyq;