mysql关联查询语句

本文主要是介绍mysql关联查询语句，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！

  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;

这篇关于mysql关联查询语句的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！