What to do if there is no RIGHT JOIN in the database, only LEFT JOIN?

It is possible to simulate a RIGHT JOIN using a LEFT JOIN by swapping the tables in the SQL query.

-- Original RIGHT JOIN
SELECT *
FROM table1
RIGHT JOIN table2 ON table1.id = table2.id;

-- Equivalent LEFT JOIN
SELECT *
FROM table2
LEFT JOIN table1 ON table2.id = table1.id;

In a RIGHT JOIN, all rows from the right table and matching rows from the left are preserved. If no match is found in the left table, NULL is returned for its columns.

By swapping the tables and using a LEFT JOIN, the same effect is achieved: all rows from what is now the left table (originally the right table in the RIGHT JOIN) are preserved, along with matching rows from the right table. NULL will be for the columns of the now right table if no match is found.