I can think of a few ways to do this

SELECT ID.ProductID, Name.ProductName

FROM Table1 AS ID

INNER JOIN Table2 AS Name

ON ID.ProductID = Name.ProductID

or

SELECT ProductID, ProductName

FROM Table2 AS 2

WHERE EXISTS (SELECT * FROM Table1 AS 1 WHERE 1.ProductID = 2.ProductID)

Both should give you a recordset you can use in your report.