What is Inner Join in SQL?
Inner Join is a keyword, which is used to select all rows from the participating tables as long as there is a match between columns.
Get familiar with the top SQL Interview Questions to get a head start in your career!
Watch this Inner Join in SQL video
Inner Join in SQL
SQL Inner join basically 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 which are common to both Table A and Table B
Interested in learning SQL? Enroll in our SQL Training now!
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 is the list of columns, table1 is the first table and table2 is the second table, and column_x and column_y are the columns for performing the inner join, followed by a semicolon.
Want to get certified in SQL! Learn from our SQL expert and do excel in your career with intellipaat’s SQL certification.
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;
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 of your data.
Visit our SQL Community to get answers to all your queries!