IFNULL
| From: | Ron Piggott | Date: | Sun, 14 Feb 2010 08:01:42 +0000 |
| Subject: | IFNULL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-46885@lists.php.net to get a copy of this message | ||
How do I add " IFNULL " to the LEFT JOIN query? I either want the result
from the database or a 0 instead of the word NULL
Ron
SELECT
store_product_profile.reference , inventory.inventory,
sold_1.quantity, sold_2.quantity, sold_3.quantity
FROM store_product_profile
LEFT JOIN (
SELECT store_product_inventory_control.store_product_profile_reference
, SUM( store_product_inventory_control.quantity ) AS inventory
FROM store_product_inventory_control
GROUP BY store_product_inventory_control.store_product_profile_reference
) AS inventory ON store_product_profile.reference =
inventory.store_product_profile_reference