Re: [PHP-DB] IFNULL

Ron Piggott wrote:
> 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`

You don't add it to the join, it goes on a field you're selecting.

select IFNULL(inventory.inventory, 0) AS blah, ....

-- 
Postgresql & php tutorials
http://www.designmagick.com/