select SUM(FIELD1) AS FIELD1, SUM(PODET.ITEM_QUANT) AS ITEM_QUANT, SUM(POREC.REC_QTY) AS REC_QTY, POREC.PODET_PK FROM POREC RIGHT JOIN PODET ON PODET.PODET_PK = POREC.PODET_PK GROUP BY PODET.PODET_PK HAVING SUM(POREC.REC_QTY) < SUM(Podet.ITEM_QUANT) > 0What if all values of REC_QTY are NULL, what would be the SUM( REC_QTY )? In my test it works, that is, the SQL creates a query. But I am not sure if it is accurate.
HAVING CASE SUM(POREC.REC_QTY) IS NULL THEN SUM(PODET.ITEM_QUANT)>0 ELSE SUM(POREC.REC_QTY < SUM( PODET.ITEM_QUANT) ENDBut I get error. I suppose I can't use IS NULL with SUM(), Correct?