Hi,
SELECT * FROM Table1 where Name in(select Name from Table2)
This will return All those product Name which is present in Table2
if you want to select those which is not in Table2 then
SELECT * FROM Table1 where Name not in(select Name from Table2)