MySQL Right Join Tutorial | Beginner Tutorial with examples

This video will discuss mysql right join with examples. Different type of joins is there : self join, inner join, left join, right join, full join and cross join.

I am using phpmyadmin for executing queries

The RIGHT JOIN keyword returns all records from the right table (table2), and the matching records from the left table (table1). The result is all records from right table, if there is no match in left table.

Here is the syntax for a right join:

SELECT column_name(s)
FROM table1
RIGHT JOIN table2

In video, example of employee with its address is shown

#knowledgethrusters #mysql #joins