In reply to Remi, here is the full code. I still get an error.
Declare @tbl table (RowId int identity(1,1), ItemName varchar(100))
Insert @tbl
Select ProductName
FROM Products
WHERE ProductName like 'M%'
Select * from @tbl INNER JOIN Products p ON @tbl.ItemName = Products.ProductName