[thelist] sql statement

[Ed McCarroll]

I don't see how that could be happening.  Are these exact cut&pastes
of the query and column titles?

> the name of the product from the short field JOIN is
> showing in both
> 
> SELECT P.productid, P.name, P.action, P.lg_picture, 
>   P.description, P.short,
>   S.abrv,
>   P2.name
> FROM products P
>   INNER JOIN prod_size PS
>     ON P.productid = PS.productid
>   INNER JOIN sizes S
>     ON PS.sid = S.sid
>   LEFT OUTER JOIN products P2
>     ON P.short = P2.productid
> WHERE P.productid = '27'
> ORDER BY P.sort_order
>
p.productid|p.name|p.action|p.lg_picture|p.description|p.short|s.abrv|p2.name
> 27|Prod2|photo.jpg|prodphoto.jpg|Description...|2|YS|Prod2 
> 27|Prod2|photo.jpg|prodphoto.jpg|Description...|2|YM|Prod2

-- 
Ed McCarroll                                  (310) 838-4330
Ed at ComSimplicity.com            http://www.ComSimplicity.com