David wrote:
>
>
> $item_query = "select inventory.discount, categories.discount from
> inventory left join categories on lower(inventory.category) =
> lower(categories.category) and lower(inventory.sub_category) =
> lower(categories.sub_category) where inventory.item_number =
> '99467BCD' ; " ;
>
>
>
try
SELECT
i.discount AS 'Inv Discount'
,c.discount AS 'Cat Discount'
,d.discount AS 'Dept Discount'
FROM
inventory i
LEFT OUTER JOIN
categories c
ON (lower(i.category) = lower(c.category) AND
lower(i.sub_category) = lower(c.sub_category))
LEFT OUTER JOIN
departments d
ON i.department = d.department
WHERE
i.item_number = '99467BCD'
