SQL
The FULL OUTER JOIN command returns all rows when there is a match in either left table or right table.