forum

home / developersection / forums / show all total matched records from 2 tables if both tables have one column same

Ask Question

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

Anonymous User 1912 16-May-2013
Hi Expert!

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

tblOrderList_INDIA

Order_ID Product_ID Customer_ID Order_Date
----------------------------------------------------------
1 10001 90001 2013-12-12
2 10002 90002 2013-06-26
3 10003 90003 2013-06-26
4 10009 90001 2013-04-05
5 10015 90123 2013-04-15

tblOrderList_US

Order_ID  Product_ID Customer_ID Order_Date
----------------------------------------------------------
1 10009 90012 2013-04-05
2 10015 90150 2013-06-15
3 10008 90261 2013-09-21

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

Please help.
Thanks in advance!


mssql server mssql server 
Updated on 16-May-2013
Anonymous User

Other

I am a content writter !

Message
Can you answer this question?
Answer

1 Answers

AVADHESH PATEL

AVADHESH PATEL

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
advertising
advertising

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy