(INNER) JOIN – returns only those records that satisfy a defined join condition in both (or all) tables. It's a default SQL join. LEFT (OUTER) JOIN – returns all records from the left table and those records from the right table that satisfy a defined join condition. RIGHT (OUTER) JOIN – returns all records from the right table and those records from the left table that satisfy a defined join condition. FULL (OUTER) JOIN – returns all records from both (or all) tables. It can be considered as a combination of left and right joins.