mysql 多表联合查询优化

最新推荐文章于 2023-10-04 18:08:13 发布

冰心丹

最新推荐文章于 2023-10-04 18:08:13 发布

阅读量747

点赞数

本文链接：https://blog.csdn.net/zm_bingxindan/article/details/37584505

版权

$sqlCompanyName = "select f.remark as cust_company from tb_group a
               inner join tb_user_group b
               on a.group_id = b.group_id
                   and a.type = 0
               inner join tb_user c
               on b.user_id = c.user_id
               left join tb_group_detail b1
               on b.group_id = b1.group_id
               left join tb_user e
               on concat(a.group_name,'_') = e.user_name
               left join tb_user_detail f
               on e.user_id = f.user_id
               where c.user_id = '".$UID."'

and a.group_id = ".$v['group_id'];

重点在于在联合查询内添加查询条件

迪卡尔乘积定律