What is Inner Join in SQL?

Inner Join is a keyword, which is used to select all rows from the participating tables in SQL as long as there is a match between columns.

 

Watch this Inner Join in SQL video

SQL INNER JOIN - Syntax and Examples

 

Inner Join in SQL

SQL Inner join gives records that have matching values in the participating tables. For example, let’s say, we have two tables, Table A and Table B. When inner join in SQL is applied on these two tables, it will get only those records that are common to both Table A and Table B
A Brief Introduction to Inner Join

Interested in learning SQL? Enroll in our SQL Training now!
 

Syntax

SELECT columns
FROM table1 name
INNER JOIN table2 name
ON table1.coumn_x = table2.column_y;

where SELECT, INNER JOIN, and ON are the keywords, columns are the list of columns, table1 is the first table, table2 is the second table, and column_x and column_y are the columns for performing the inner join, followed by a semicolon.

Become a Database Architect

 

Example

Let’s apply inner join to two tables, the employee table, and the department table

Select employee.e_name, employee.e_dept, department.d_name, department.d_location from employee
INNER JOIN department
ON employee.e_dept = department.d_name;

A Brief Introduction to Inner Join 1
After writing the query, click on the execute button to check for errors. Once the query is executed, a message appears like ‘Commands completed successfully.
This brings us to the end of this Inner Join in SQL tutorial section. Go ahead and link the tables from your database to get a better insight into your data.

Visit our SQL Community to get answers to all your queries!

Course Schedule

Name Date
SQL Training 2022-06-25 2022-06-26
(Sat-Sun) Weekend batch
View Details
SQL Training 2022-07-02 2022-07-03
(Sat-Sun) Weekend batch
View Details
SQL Training 2022-07-09 2022-07-10
(Sat-Sun) Weekend batch
View Details

Leave a Reply

Your email address will not be published. Required fields are marked *