MYSQL - RIGHT JOIN Query

RIGHT JOIN Query in mysql is used to join multiple tables which return all the records from the second (right side) table even no matching records found from the first (left-side) table. If it will not find any matches record from the left side  first table, then returns null.

• We can use MySQL RIGHT JOIN Multiple Tables.
• We can use RIGHT JOIN with WHERE Clause.
• We can use MySQL RIGHT JOIN with Group By Clause.
• We can use MySQL RIGHT JOIN with USING Clause.

MYSQL Syntax :

SELECT field_name1, field_name2, ....
FROM table1
RIGHT JOIN table2
ON Join_Condition;



MYSQL Query Example :
SELECT s.stud_id,s.stud_name,m.maths,m.science FROM tblstudent s RIGHT JOIN tblmarks m on s.stud_id=m.stud_id

Explain: 

• The tblstudent is the left table and tblmarks is the right table.

• The RIGHT JOIN returns all rows from the table tblmarks matched records from the table tblstudent.

• The RIGHT JOIN returns all rows from the right table tblmarks even if there are no matched in the left table (tblstudent) with null value.