ilan - it would really help if you post the ddls of your tables and your end goal...given what there is, this is what it appears you want...
SELECT * FROM Table_Product_id TP
WHERE NOT EXISTS
(SELECT * FROM Products P WHERE TP.ProductID = P.ProductID)
or
SELECT * FROM Table_Product_id TP
LEFT OUTER JOIN
Products P ON
TP.ProductID = P.ProductID
you can tweak these around depending on your tables and what results you want to see!
**ASCII stupid question, get a stupid ANSI !!!**