Problem With A View (not A Simple One)

Hi,

I have a table that is something like this:

Products ----------------- idProduct as int, idPart1 as int, idPart2 as int, idPart3 as int

then other table, which is something like:

Parts: ---------------------- idPart as int, partName as VarChar(30)

Now, some products only take one part, but others will take as many as 3 parts. Since it's a relatively small number I thought it would be better to put 3 different idParts on the product table and have two of them allow nulls, instead of creating a Master / Detail kind of thing. My question is, how do I create a view with something like:

v_Products ----------------- idProduct as int, namePart1 as VarChar(30), namePart2 as VarChar(30), namePart3 as VarChar(30)

I'm using SQL Server 2005 (Express Edition, but the SQL is the same so...). I'm using this code:

SELECT dbo.products.idProduct, dbo.parts1.partName, dbo.parts2.partName, dbo.parts3.partName FROM dbo.products INNER JOIN dbo.parts AS parts1 ON dbo.products.idPart1=parts1.idPart INNER JOIN(...)

Help? :s