mysql---复杂的语句关联查询

最新推荐文章于 2023-08-11 08:58:26 发布

weixin_34419321

最新推荐文章于 2023-08-11 08:58:26 发布

阅读量110

点赞数

文章标签：数据库 python

原文链接：https://my.oschina.net/zhangdapeng89/blog/40401

版权

2019独角兽企业重金招聘Python工程师标准>>>

SELECT o.*,g.or_id,g.id,g.state,op.name as type_name,c.name as country,s.name as country_state 
                        FROM groups AS g, organization AS o,organization_type AS op,country AS c,state AS s
                        WHERE o.id = g.or_id 
                        AND g.id IN (
                            SELECT group_id 
                            FROM manager_has_group 
                            WHERE manager_id = {$userInfo['id']})
                        AND op.id = o.type_id 
                        AND s.id = o.state AND c.id = o.country_id ORDER BY g.id DESC

转载于:https://my.oschina.net/zhangdapeng89/blog/40401