0 votes
in Sql by
What is the Right JOIN in SQL?

1 Answer

0 votes
by

The Right join is used to retrieve all rows from the right-hand table and only those rows from the other table that fulfilled the join condition. It returns all the rows from the right-hand side table even though there are no matches in the left-hand side table. If it finds unmatched records from the left side table, it returns a Null value. This join is also known as Right Outer Join.

The below visual representation explain this join more clearly:

SQL Interview Questions and Answers

The following syntax illustrates the RIGHT JOIN:

SELECT colum_lists    

FROM table1     

RIGHT JOIN table2    

ON join_condition;  

Related questions

0 votes
0 votes
0 votes
0 votes
asked Jul 8, 2020 in Sql by Robindeniel
+2 votes
0 votes
asked Nov 8, 2021 in Sql by rajeshsharma
...