The RIGHT JOIN
clause is similar to the LEFT JOIN
clause, with the only difference being that the right table is considered the primary table and the left table is considered the secondary table. The RIGHT JOIN
clause returns all the rows from the right table and the matching rows from the left table, and any non-matching rows from the left table will have NULL values.
For example, if we have a table named employees
and another table named departments
, and we want to retrieve all the departments and the employees working in each department, including departments with no employees, we can use a RIGHT JOIN
:
SELECT departments.department_name, employees.employee_name
FROM departments
RIGHT JOIN employees
ON departments.department_id = employees.department_id;
In this example, the RIGHT JOIN
clause will return all the departments and their matching employees, and any departments with no employees will have NULL values for the employee_name
column.
The RIGHT JOIN
clause is useful when you want to retrieve all the records from the right table and only the matching records from the left table, or to retrieve all the records from the right table and include data from the left table only if a match exists.
Also check WHAT IS GIT ? It’s Easy If You Do It Smart
You can also visite the Git website (https://git-scm.com/)