Cross Join will return all records where each row from the first table is combined with each row from the second table.