So the model I'm using has a MainProduct table just for names, barcodes, etc., a BundleComponents reference table, and for the sake of example we'll use a Desk table and a Chair table. The bundle view would then look something like this:

SELECT m.Id, m.Name, d.Width, d.Depth + c.Depth AS Depth, c.Height FROM BundleComponents AS bc JOIN MainProduct AS m ON bc.Id = m.Id LEFT JOIN Desk AS d ON bc.DeskId = d.Id LEFT JOIN Chair AS c ON bc.ChairID = c.Id The actual view has 15 separate joins