hi! to all.

Sorry for the previous post I accidentally hit enter.
this is the original post.


I have 2 table I called it. tbl_1 and tbl_2.

I use inner join to list all the records that are match in tbl_1 and tbl_2
I want the result to show all the records that not match in tbl_1 and tbl_2

below is the list of table that I am using.

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

this is my SQL stament
================================================== =============
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

Result I want to achieve.

---------------------
ProductID | Product
---------------------
PH6 | CDROM
PH7 | Video Card


hope you can help me with this problem.

Thanks,
Rylemer

To get the records in table2 that are not in table1, you can do the following:

SELECT tbl_2.ProductID, tbl_2.Product
FROM tbl_2 LEFT OUTER JOIN tbl_1
  ON tbl_1.ProductID=tbl_2.ProductID
WHERE tbl_1.ProductID IS NULL

Regards,
SQL Server Helper
http://www.sql-server-helper.com

sshelper,

Cool It worked thanks for you help.

Thanks,
Rylemer