SQL INNER JOIN


The most frequently used and important of the joins is the SQL INNER JOIN.

The SQL INNER JOIN clause selects all records or rows from both tables (tableA and tableB) and returns a result table by combining field or column values of two tables that is limited to the records as long as where there is a match keys in both tables.

You can also search these topics using sql update inner join, inner join 3 tables, multiple inner joins, inner join example, select inner join, inner join syntax, sql inner join three tables, sql delete from inner join, left join inner join, inner join 2 tables, inner join on multiple tables, inner join multiple tables, inner join sql example, select from inner join.

SQL INNER JOIN Syntax

Syntax for Inner Join is as


SELECT column_name1, column_name2, ...column_nameN
FROM table_name1
INNER JOIN table_name2
ON table1.column_name1 = table2.column_name1;

or


SELECT column_name1, column_name2, ...column_nameN
FROM table_name1
JOIN table_name2
ON table1.column_name1 = table2.column_name1;

Note: INNER JOIN is the same as JOIN.

SQL INNER JOIN

Sample Database Table - Books

BookId BookName BookPrice RelYear DomainName AuthorName
1 The Complete Guide to MySql 120 2014 Optimization Dharan
2 Securing Oracle 165 2013 Administration Balan
3 Natural language Query To SQL 190 2014 Programming Ranjani Mai
4 SQL Pocket Guide 160 2015 Security Siva Kumar
6 PHP And MySQL Bible 90 2010 Performance Rishi Keshan

Sample Database Table - BookOrder

BookID OrderDate Qty DeliveryDate
1 15-04-2011 2 17-05-2011
2 15-05-2000 16 24-05-2000
3 17-09-1997 17 25-10-1997
4 20-08-2005 9 27-09-2005
5 11-06-1995 8 26-07-1995

Note:- There must be a common columns while selecting columns from multiple tables. In the "BookOrder" and "Books" both tables contains a common column called "ID".

SQL INNER JOIN - Example

Notice that the "BookID" column in the "Books" table refers to the "ID" in the "BookOrder" table. The relationship between the two tables above is the "BookID" column.

Then, if we run the following SQL statement (that contains an INNER JOIN):


SELECT 
Books.BookID, Books.BookName, BookOrder.Qty, BookOrder.OrderDate
FROM Books
INNER JOIN BookOrder
ON Books.BookID = BookOrder.BookID;

The result of above query is:

BookID BookName Qty OrderDate
1 The Complete Guide to MySql 2 15-04-2011
2 Securing Oracle 16 15-05-2000
3 Natural language Query To SQL 17 17-09-1997
4 SQL Pocket Guide 9 20-08-2005

Note: If there are rows in the "Books" table that do not have matches in "BookOrder", these Books will NOT be listed.

You can also search these topics using sql command inner join, sql 2 inner joins, 3 table inner join, sql statement inner join, inner join explained, inner join with where condition, sql query for inner join, sql inner join order by, sql multiple inner join example, inner join database, sql inner join and outer join, sql inner join performance, sql joins with examples, joins in sql with examples, sql multiple joins, sql tutorial joins, sql join multiple tables, left outer join multiple tables, join multiple tables sql, sql left join multiple tables.