Which join operation returns all records when there is a match in left (table1) or right (table2) table records.? code example

Matching part from both table and unmatching part from left table.