If you want to combine the results of both LEFT and RIGHT join than we use FULL JOIN keyword. The joined table which created after FULL JOIN contains all records from both the two tables, and fills null value for those places where missing matches take place.
Below is the syntax of FULL JOIN :-
FULL JOIN tablename2
ON tablename1.commonname = tablename2.commonname;
Below is the customers table for explain FULL JOIN:-