Yogesh Chauhan's Blog

SQL Right Join

in SQL/MySQL on August 31, 2019


As the name suggests the SQL right join displays all the records from the right side table and all the matching records from the left side table. Let’s take a look at the syntax. 

SELECT column/columns
FROM table_left RIGHT JOIN table_right
ON table_left.column= table_right.column;

As you can see in the syntax above, the query will show all the records from the table on the right side (table_right) and also the matched records form the table on the left side (table_left).

Let’s take a look at the example:

SELECT country.Region, countrylanguage.Language, country.Name, country.Code
FROM country
RIGHT JOIN countrylanguage ON country.Code=countrylanguage.CountryCode ORDER BY Code LIMIT 10;

It’s the same example form LEFT join article. The only difference is the RIGHT join keyword.

In the example above, I am selecting the columns Region, Name and Code from country table and Language from countrylanguage table. As I’ve discussed before the table on the right side will have it’s all records pulled up and displayed, which in this example, is countrylanguage table. Then the query watches out for the similar records in  both the tables and then displays those records from the tables.

If the records are exactly matching from all the columns requested then it will only display single entry otherwise there will be multiple lines of display. For example, let’s say the language is different for matching records for AFG country code. Then it will create a row with all the records form left column and then create one more row for the matching records with entries from the right table.

I’ve set the LIMIT 10 as both of tables have approx. 100 lines of records.

Most Read

#1 How to check if radio button is checked or not using JavaScript? #2 Solution to “TypeError: ‘x’ is not iterable” in Angular 9 #3 How to add Read More Read Less Button using JavaScript? #4 How to uninstall Cocoapods from the Mac OS? #5 PHP Login System using PDO Part 1: Create User Registration Page #6 How to Use SQL MAX() Function with Dates?

Recently Posted

#Aug 15 Is PHP still good for back-end programming? #Aug 10 How to create a multisite network in WordPress? #Aug 3 How to create a circle that follows a cursor using JavaScript and CSS? #Aug 3 How to make a curtain slider using jQuery and CSS? #Aug 2 How to progressively load images and add a blurry placeholder? #Aug 1 How to create a placeholder loader (throbber) using CSS?
You might also like these
How to add onclick event to html elements dynamically using JavaScript?JavaScriptWhat’s new in WordPress 5.5?WordPressJavaScript String fromCharCode() MethodJavaScriptHow to redirect or load a new document using JavaScript?JavaScriptHow to install Gulp with WordPress?WordPressWhat Is a Graph Database?Miscellaneous