RIGHT JOIN
A RIGHT JOIN is a type of SQL operation that combines rows from two tables based on a related column. In this join, all records from the right table are included in the result set, even if there are no matching records in the left table. If there is no match, the result will show NULL values for the columns from the left table.
For example, if you have a table of employees and a table of departments, a RIGHT JOIN will return all departments, including those without any employees assigned. This ensures that every department is represented, regardless of whether it has employees.