[thelist] SQL: looking for resources, have one question

Chris W. Parker cparker at swatgear.com
Tue Oct 22 16:33:01 CDT 2002


> -----Original Message-----
> From: rudy [mailto:r937 at interlog.com]
>
> thanks for the table layouts, they helped me understand

good.

> here's a query that lists all products and their adverts
>
> select ppName
>      , paname
>      , ptComments
>      , ptUsername
>      , ptDate
>   from PossibleProducts
> left outer join
>        ( productTracking
>    left outer join PossibleAdverts
>       on ptReferralSource = PossibleAdverts.id )
>     on PossibleProducts.id = ptProduct
> order by ppName, ptDate

thanks for all your help rudy. i think we can count this one as solved.
^
|
|
|
 again,
chris.



More information about the thelist mailing list