[thelist] sql statement
Ed McCarroll
Ed at ComSimplicity.com
Wed Mar 30 15:44:08 CST 2005
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
More information about the thelist
mailing list