Using the SQL Server INNER JOIN Clause
SQL INNER JOIN fundamentals
SQL JOIN clauses retrieve data from two or more database tables and present that data in a result table based on a related column between the tables that are queried. The INNER JOIN is the most common of all.
What is INNER JOIN in SQL?
The INNER JOIN is used to fetch records that have matching values in two or more tables. Hence, the result table is created containing matching rows in all these tables.