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
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
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/)