---
title: "show all total matched records from 2 tables if both tables have one column same"  
description: "show all total matched records from 2 tables if both tables have one column same"  
author: "Anonymous User"  
published: 2013-05-16  
updated: 2013-05-16  
canonical: https://www.mindstick.com/forum/900/show-all-total-matched-records-from-2-tables-if-both-tables-have-one-column-same  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

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

Hi [Expert](https://www.mindstick.com/articles/13120/an-expert-financial-advice-will-improve-your-finances)!\
I want to get total [matched](https://answers.mindstick.com/qa/95756/what-are-the-benefits-of-google-adsense-matched-content) [records](https://www.mindstick.com/forum/34640/how-to-create-a-stored-procedure-for-display-all-records) from 2 [tables](https://www.mindstick.com/articles/336597/introduction-of-html-tables-for-web-development). Tables and [data](https://www.mindstick.com/articles/13050/salesforce-aiming-to-dominate-predictive-analytics-with-data-science) are as following\
tblOrderList_INDIA\
Order_ID Product_ID Customer_ID Order_Date----------------------------------------------------------1 10001 90001 2013-12-122 10002 90002 2013-06-263 10003 90003 2013-06-264 10009 90001 2013-04-055 10015 90123 2013-04-15\
tblOrderList_US\
Order_ID Product_ID Customer_ID Order_Date----------------------------------------------------------1 10009 90012 2013-04-052 10015 90150 2013-06-153 10008 90261 2013-09-21\
I want to get [match](https://www.mindstick.com/forum/159713/regex-match-attribute-in-an-html-code) customer_id from both [table](https://www.mindstick.com/articles/43918/how-to-design-table-using-bootstrap)(tblOrderList_INDIA, tblOrderList_US).\
Please help.Thanks in [advance](https://www.mindstick.com/blog/33258/jee-mains-and-jee-advance-exams)!\
\

## Replies

### Reply by AVADHESH PATEL

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


---

Original Source: https://www.mindstick.com/forum/900/show-all-total-matched-records-from-2-tables-if-both-tables-have-one-column-same

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.