Hi Ed,
> How do I prevent IFNULL and ISNULL from returning a null?
>
> I have the following query where this is occurring,
>
> Select IFNULL(sum(qty),0)
> from inventory
> where partnumber=111
> group by partnumber;
>
> If the partnumber has never been in inventory then the sum and ifnull
> functi
How do I prevent IFNULL and ISNULL from returning a null?
I have the following query where this is occurring,
Select IFNULL(sum(qty),0)
from inventory
where partnumber=111
group by partnumber;
If the partnumber has never been in inventory then the sum and ifnull
functions both return null. If
