怎样将这两个语句合在一起，

Question

跪求大神帮助，，

怎样将这两个语句合在一起，， 一个条件是 T3.CH_SIZE = '20'‘

一个条件是T3.CH_SIZE = '40' ，，合成四列，，每列都是独立的，，主要是COUNT(T3.CH_SIZE)，，这两列，，

SELECT T2.CH_BL_NO,
COUNT(T3.CH_SIZE)
FROM JB_NA_OUTSTANDING_TBL T1
LEFT JOIN BL_CONTAINERINFO_TBL T2
ON T1.VR_BL_NO = SUBSTR(T2.CH_BL_NO, 5, 13)
LEFT JOIN MS_CNTRINFO_TBL T3
ON T2.VR_CNT_SZ_TYP = T3.CH_SIZE_TYPE_CD
WHERE T3.CH_SIZE = '20'
GROUP BY T2.CH_BL_NO

SELECT T2.CH_BL_NO,
COUNT(T3.CH_SIZE)
FROM JB_NA_OUTSTANDING_TBL T1
LEFT JOIN BL_CONTAINERINFO_TBL T2
ON T1.VR_BL_NO = SUBSTR(T2.CH_BL_NO, 5, 13)
LEFT JOIN MS_CNTRINFO_TBL T3
ON T2.VR_CNT_SZ_TYP = T3.CH_SIZE_TYPE_CD
WHERE T3.CH_SIZE = '40'
GROUP BY T2.CH_BL_NO

Answer 1

用union将两个select的结果集联合起来，然后对这个结果可以再次进行select和count计算