SQL Query to Find Common Records Between Two Tables

Problem

Given two tables, A and B, write a SQL query to find the common records between the two tables.
Example input:
A:
id | name
1 | John
2 | Doe
3 | Smith
4 | Jane
B:
id | name
1 | John
2 | Smith
3 | Jane
4 | Doe
5 | Johnson
Example output:
id | name
1 | John
2 | Smith
3 | Jane
4 | Doe

Solution

This solution is in SQL. Our A.I. can create solutions in multiple languages.

sarastevens

SELECT A.id, A.name
FROM A
INNER JOIN B
ON A.id = B.id
AND A.name = B.name;

/*

The above solution is optimal because it uses an inner join to find the common records between the two tables.

*/