Figure 10 CTE Joined to the Products Table
　

ProductID   Name                            Qty
---------- ------------------------------ ------------------
1           Adjustable Race                 1
2           Bearing Ball                    100
3           LL Bottom Bracket               1
...
835         Metal Sheet 5                   2
835         Metal Sheet 5                   1
835         Metal Sheet 5                   2
...

(90 row(s) affected)