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