[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