Posted by Mintyman on 11/13/06 15:54

Hi Mark,

Thanks very much! I would never have gotten there on my own!

Mintyman


<markc600@hotmail.com> wrote in message
news:1163429919.872807.120980@b28g2000cwb.googlegroups.com...
> SELECT a.ProductID,
> a.Name,
> a.Description,
> p1.Price AS Price1,
> p2.Price AS Price2,
> p3.Price AS Price3,
> p4.Price AS Price4,
> p5.Price AS Price5
> FROM Product a
> LEFT OUTER JOIN ProductProgram p1 ON p1.ProductID=a.ProductID AND
> p1.Level=1
> LEFT OUTER JOIN ProductProgram p2 ON p2.ProductID=a.ProductID AND
> p2.Level=2
> LEFT OUTER JOIN ProductProgram p3 ON p3.ProductID=a.ProductID AND
> p3.Level=3
> LEFT OUTER JOIN ProductProgram p4 ON p4.ProductID=a.ProductID AND
> p4.Level=4
> LEFT OUTER JOIN ProductProgram p5 ON p5.ProductID=a.ProductID AND
> p5.Level=5
>

• Next in forum: Re: Please Help With Complex Update Statement Logic
• Prev in forum: Re: Newbie needing help creating query
• Thread view: Re: Newbie needing help creating query

[Reply to this message]