阅读背景:

[MySQL] MySQL联表查询的执行顺序优化查询

来源:互联网 
SELECT t4.orgName,
                   t3.projectName,
                   t3.Partner,
                   t1.type,
                   COUNT(DISTINCT t1.imei) AS count
            FROM `t_teminal` AS t1
            LEFT JOIN `t_orgcode_orgid_rela` AS t2
              ON t1.orgid = t2.orgId
            LEFT JOIN `t_org_code` AS t3
            ON t2.topOrganizationCode = t3.topOrganizationCode
            LEFT JOIN `t_organization` AS t4
            ON t1.orgid = t4.orgId
            GROUP BY t1.orgid
SELECT t4.orgName,
                   t3.pr



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: