[php-list] Re: getting a value from a join

[David]

thanks, I tried that:
$item_query =  " 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 =
'MB99467BCD' ; " ;

and get this error message:

You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'category) = 'lower(c.sub_ category)' ) LEFT OUTER JOIN departme



--- In php-list@yahoogroups.com, Brian Cummiskey <[EMAIL PROTECTED]> wrote:


>
> 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'
>