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;
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步