select TABLE1.*, NVL(C_USED.USED_QUANTITY,0) AS USED_QUANTITY FROM TABLE1 LEFT JOIN (select TABLE2.PART_NO, NVL(SUM(TABLE2.USED_QTY),0) as USED_QUANTITY, FROM TABLE2 GROUP BY TABLE2.PART_NO) C_USED ON TABLE1.PART_NO = C_USED.PART_NOThe above SQL Select gets a query that has a column USED_QUANITY with all different values and specifically some with value of 0 (zero).
select TABLE1.*, NVL(C_USED.USED_QUANTITY,0) AS USED_QUANTITY FROM TABLE1 LEFT JOIN (select TABLE2.PART_NO, NVL(SUM(TABLE2.USED_QTY),0) as USED_QUANTITY, FROM TABLE2 GROUP BY TABLE2.PART_NO) C_USED ON TABLE1.PART_NO = C_USED.PART_NO AND USED_QUANTITY < 10Why does the second SQL Select not selecting records of 0 quantity?