Right Join is a keyword, which is used to select all rows from the right table and also the matched values between the two tables.
The Right Join basically returns all records from the right table and the matched records from the left table. For example, let’s say, we have two tables, Table A and Table B, when left join is applied on these two tables, it would give all records from Table B and only the matched records from Table A.
SELECT columns FROM table1 name RIGHT JOIN table2 name ON table1.coumn_x = table2.column_y;
where SELECT, RIGHT 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 Right Join, followed by a semicolon.
Let’s apply Right 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 RIGHT 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 tutorial section. Go ahead and link the tables from your database to get a better insight of your data. In the next tutorial section, we will discuss on the Full Join.Previous Next
Download Interview Questions asked by top MNCs in 2019?