Doris 数据查询时，返回的记录数少于底表符合条件的记录数，丢失数据

SELECT
A.UNIT_ID,COUNT()
FROM DX_SSP A
JOIN DX_SSP_DTL B ON B.UNIT_ID =A.UNIT_ID AND A.SSP_NUM =B.SSP_NUM
WHERE CANCELLED='F' AND A.UNIT_ID =197
GROUP BY A.UNIT_ID;
能够查询到记录
去掉上述语句中的 A.UNIT_ID =197 条件，则查不到该记录了
SELECT
A.UNIT_ID,COUNT()
FROM DX_SSP A
JOIN DX_SSP_DTL B ON B.UNIT_ID =A.UNIT_ID AND A.SSP_NUM =B.SSP_NUM
WHERE CANCELLED='F'
GROUP BY A.UNIT_ID;

！！！！这条记录就丢失了！！！！