多表联查，两表之间相互关联，不一定需要有主外键关系，字段匹配就行

最新推荐文章于 2024-08-20 04:56:33 发布

josnow

最新推荐文章于 2024-08-20 04:56:33 发布

阅读量2w

点赞数 4

分类专栏： sql 文章标签： sql

本文链接：https://blog.csdn.net/josnow/article/details/72478605

版权

sql 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

Set @dlr = 15001;

SELECT school.name AS schoolName, xq.xqmc AS xqmc, qy.mc as qymc, ly.bz as lymc, fj.bz as fjmc FROM t_xsgy_ssap ssap
               LEFT JOIN t_xsgy_cwgl cwgl ON cwgl.id=ssap.cwid
               LEFT JOIN t_baseinfo_fj fj ON fj.id = cwgl.fj
               LEFT JOIN t_baseinfo_ly ly ON fj.lyid = ly.id
               LEFT JOIN t_baseinfo_qy qy ON ly.qyid = qy.id
               LEFT JOIN t_sys_school school ON ssap.ssxxid = school.id
               LEFT JOIN t_baseinfo_xq xq ON qy.ssxq = xq.id
       WHERE ssap.xhid = @dlr
               AND ssap.zszt =1