如何获取left join后,符合条件的有多少条
SELECT a.*,
COUNT(*) AS 'population'
FROM `course_degree` a
LEFT JOIN course_package cp ON cp.`courOrDegrCode` = a.`DEGR_CODE`
LEFT JOIN (SELECT *
FROM contract_course_package
WHERE CONT_PACK_STAR >= '2018-05-08'
GROUP BY pack_code,
chil_code) ccp ON ccp.`PACK_CODE` = cp.`PACK_CODE`
LEFT JOIN contract c ON c.`cont_code` = ccp.`CONT_CODE`
LEFT JOIN (SELECT *
FROM `fund_income_print` GROUP BY cont_code) f ON f.cont_code = c.`cont_code`
LEFT JOIN
(SELECT a.*,
cp.cont_code,
cp.pers_code,
cp.pers_name
FROM course_arrange a
LEFT JOIN (SELECT *
FROM `course_person`
WHERE cont_code IS NOT NULL) cp ON cp.pare_id = a.`AUTO_ID`
LEFT JOIN sys_office o ON o.id = a.`TRAI_CODE`
WHERE cp.cont_code IS NOT NULL AND a.`ARRA_DATE` >= '2018-05-08'
AND ( o.id = 1 OR o.parent_ids LIKE CONCAT('%,', 1, ',%')) GROUP BY cp.pers_code,
a.COUR_DEGR) ca ON ca.`COUR_DEGR` = a.`DEGR_CODE`
LEFT JOIN sys_office o ON o.id = f.trai_code
WHERE a.`del_flag` = 0
AND f.inco_code IS NOT NULL
AND ( o.id = 1 OR o.parent_ids LIKE CONCAT('%,', 1, ',%'))
GROUP BY a.`DEGR_CODE`如题
我想知道ca表left join 符合条件的有多少条
...全文
相关推荐
oracle超牛笔记
想学好oracle的 只需要看这个文档你就会明白了,简单明了,通俗易懂
mysql, LEFT OUTER JOIN 与 LEFT JOIN,RIGHT OUTER JOIN 与RIGHT JOIN ,FULL OUTER JOIN 与 FULL JOIN区别与联系
I have seen joins called LEFT OUTER JOIN or RIGHT OUTER JOIN. In some places I have seen LEFT JOIN or RIGHT JOIN. I am confused by this. I posted a question 2 days ago, but I am unable to understand ...
魔乐在线Oracle笔记超经典.docx
魔乐在线Oracle笔记超经典.docx
SQL中的left join right join
数据库常见的join方式有三种:inner join, left outter join, right outter join(还有一种full join,因不常用,本文不讨论)。这三种连接方式都是将两个以上的表通过on条件语句,拼成一个大表。
SQL之left join、right join、inner join的区别浅析
主要介绍了SQL之left join、right join、inner join的区别浅析,本文讲解了它们的区别并给出了实例,需要的朋友可以参考下



