---
title: "How to fetch same record from two table in SQL Server?"  
description: "How to fetch same record from two table in SQL Server?"  
author: "Steilla Mitchel"  
published: 2021-11-18  
updated: 2021-11-18  
canonical: https://www.mindstick.com/forum/156852/how-to-fetch-same-record-from-two-table-in-sql-server  
category: "mssql server"  
tags: ["sql server", "sql"]  
reading_time: 1 minute  

---

# How to fetch same record from two table in SQL Server?

How to [fetch](https://www.mindstick.com/forum/156159/what-is-google-fetch) same record from two [table in SQL](https://www.mindstick.com/forum/205/find-the-all-column-with-schema-for-any-table-in-sql-server) [Server](https://www.mindstick.com/articles/43769/what-is-serverless-architecture-is-it-worth-switching-over)?

## Replies

### Reply by Ashutosh Kumar Verma

**Fetch same Record from Two [table](https://www.mindstick.com/articles/43918/how-to-design-table-using-bootstrap):**

The INTERSECT Operator is used to find the same record from two database in [SQL Server](https://www.mindstick.com/articles/12999/what-is-table-valued-function-in-sql-server).

Let us create two table Employees and Manager

**Employees table:**![How to fetch same record from two table in SQL Server?](https://www.mindstick.com/mindstickforums/4fd5c219-7315-4d20-91bb-3078c9a69119/images/685b5611-04db-4784-8001-0cd8125139f4.png)

**Manager table:**![How to fetch same record from two table in SQL Server?](https://www.mindstick.com/mindstickforums/4fd5c219-7315-4d20-91bb-3078c9a69119/images/31530eaa-f024-49b8-86a7-78306c7aec15.png)

Now, the following SQL statement is find the same record from above both table by using INTERSECT Clause,

![How to fetch same record from two table in SQL Server?](https://www.mindstick.com/mindstickforums/4fd5c219-7315-4d20-91bb-3078c9a69119/images/9b241fb1-bae0-403c-af07-e5bb87e46366.png)\

## Output:

![How to fetch same record from two table in SQL Server?](https://www.mindstick.com/mindstickforums/4fd5c219-7315-4d20-91bb-3078c9a69119/images/91cea5bf-3fe0-472f-80b8-67a8b2935a8c.png)


---

Original Source: https://www.mindstick.com/forum/156852/how-to-fetch-same-record-from-two-table-in-sql-server

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