SQL RIGHT JOIN

SQL RIGHT JOIN Syntax

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

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

Note: In some databases RIGHT JOIN is called RIGHT OUTER JOIN.

Sample Database Table - Books

Sample Database Table - BookOrder

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 RIGHT JOIN - Example

Notice that the "BookID" column in the "Books" table refers to the "BookID" 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 RIGHT JOIN):

SELECT 
BookOrder.BookID, BookOrder.BookName, Books.BookPrice, Books.RelYear, BookOrder.DeliveryDate
FROM Books
RIGHT JOIN BookOrder
ON Books.BookID = BookOrder.BookID;

The result of above query is:

Note: The SQL RIGHT JOIN keyword returns all the records from the right side table (Books), even if there are no matches in the left side table (BookOrder).