tbl_1
-------------------------
ProductID | Product
-------------------------
PH1 | Mouse
PH2 | KeyBoard
PH3 | Monitor
PH4 | CPU
PH5 | Headset

tbl_2
--------------------------
ProductID | Product
--------------------------
PH1 | Mouse
PH2 | KeyBoard
PH3 | Monitor
PH6 | CDROM
PH7 | Video Card


SELECT tbl_1.ProductID, tbl_1.Product
FROM tbl_1 INNER JOIN tbl_2 ON tbl_1.ProductID=tbl_2.ProductID;

---------------------
ProductID | Product
---------------------
PH1 | Mouse
PH2 | KeyBoard
PH3 | Monitor

So what is your question?

What do you need?
Left Join? Full Outer Join???

“I sense many useless updates in you... Useless updates lead to defragmentation... Defragmentation leads to downtime...Downtime leads to suffering..Defragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" -- http://sqlservercode.blogspot.com/

Answer is:

Yes those are two tables and a select statement.