forum

Home / DeveloperSection / Forums / show all total matched records from 2 tables if both tables have one column same

show all total matched records from 2 tables if both tables have one column same

Anonymous User170516-May-2013

Hi Expert!

I want to get total matched records from 2 tables. Tables and data are as following

tblOrderList_INDIA

Order_IDProduct_ID Customer_ID Order_Date

----------------------------------------------------------

110001900012013-12-12

210002900022013-06-26

310003900032013-06-26

410009900012013-04-05

510015901232013-04-15

tblOrderList_US

Order_ID Product_ID Customer_ID Order_Date

----------------------------------------------------------

110009900122013-04-05

210015901502013-06-15

310008902612013-09-21

I want to get match customer_id from both table(tblOrderList_INDIA, tblOrderList_US).

Please help.

Thanks in advance!

Updated on 16-May-2013

I am a content writter !

Can you answer this question?

Answer

16-May-2013

Hi Hugh!

Use Inner join to get matching data as following

SELECT ind.Customer_ID as 'Customer_ID' FROM tblOrderList_INDIA ind inner join tblOrderList_US us on ind.Product_ID = us.Product_ID