How would you retrieve common records from two tables ?

Hi,

To learn about how to find common records from two tables, visit:

• https://www.sqlshack.com/sql-intersect-use-in-sql-server/
• https://www.c-sharpcorner.com/blogs/fetch-only-common-records-from-two-tables

Thanks!

Hi Naresh,

You can use Intersect or Inner Join to get common records from two tables.

Hi Naresh,

Use Intersect Key word, which gives you common records.

SELECT column1
FROM table1
INTERSECT
SELECT column1
FROM table2

If you want in the output both column1 and column2 from table1 which has common columns1 in both tables.

SELECT column1, column2
FROM table1
WHERE column1 IN
(
SELECT column1
FROM table1
INTERSECT
SELECT column1
FROM table2
)

(Select * from student) Intersect (Select * from student1)

https://www.c-sharpcorner.com/blogs/fetch-only-common-records-from-two-tables

Hi Naresh Beniwal,

INTERSECT can be used in MS SQL to retrieve common records from two tables as like following:

SELECT Subject_code FROM students
INTERSECT
SELECT Subject_code FROM teacher;

For more details:

• How do you fetch common records from two tables in SQL?
  • https://www.quora.com/How-do-you-fetch-common-records-from-two-tables-in-SQL

Hope, this will help you!