>Suppose I have the following SQL Select:
>
>

>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) > 0
>

>
>What 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.
>
>I tried to change the HAVING to something like this:
>
>

>HAVING CASE SUM(POREC.REC_QTY) IS NULL THEN SUM(PODET.ITEM_QUANT)>0 ELSE 
>SUM(POREC.REC_QTY < SUM( PODET.ITEM_QUANT) END
>

>
>But I get error. I suppose I can't use IS NULL with SUM(), Correct?

If all REC_QTY are NULLs then the result of SUM() will be NULL you will not get any records.