SQL OUTER JOINS SQL OUTER JOINS are of 3 types: LEFT JOIN or LEFT OUTER JOINRIGHT JOIN or RIGHT OUTER JOINFULL JOIN or FULL OUTER JOIN Learn more : SQL Tutorial , SQL Interview Questions