[thelist] sql statement

[Dan McCullough]

wow thats awesome.  :)

now a follow up question is and this gets to where I'm seeing if what
it returned is a good thing or a bad thing.

What I got back is what I asked for, but because size is returning
more then one result, because the sizes for this product is more then
one.  what i got back was the product listed 9 times, one for each
size in the product.



On Wed, 30 Mar 2005 11:38:07 -0800, Ed McCarroll <Ed at comsimplicity.com> wrote:
> Dan,
> 
> I suspect you want to something that looks like this:
> 
>  SELECT P.productid, P.<fields from first product record>,
>         S.abrv,
>         P2.<fields from related product record>
>  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
>      <OUTER in case there is no related record>
>      ON P.<related productid> = P2.productid
>  WHERE <all that script stuff>
>  ORDER BY P.sort_order
> 
> --
> Ed McCarroll                                  (310) 838-4330
> Ed at ComSimplicity.com            http://www.ComSimplicity.com
>