The SQL full join is the result of combination of both left and right outer join and the join tables have all the records from both tables. It puts NULL on the place of matches not found.
SQL full outer join and SQL join are same. generally it is known as SQL FULL JOIN.
What is SQL full outer join?
SQL full outer join is used to combine the result of both left and right outer join and returns all rows (don?t care its matched or unmatched) from the both participating tables.Syntax for full outer join:
SELECT * FROM table1 FULL OUTER JOIN table2 ON table1.column_name = table2.column_name;
When each row of first table is combined with each row from the second table, known as Cartesian join or cross join. In general words we can say that SQL CROSS JOIN returns the Cartesian product of the sets of rows from the joined table.We can specify a CROSS JOIN in two ways:
SELECT * FROM [TABLE1] CROSS JOIN [TABLE2]
SELECT * FROM [ TABLE1] , [TABLE2]SQL Statement:
SELECT * FROM MatchScore CROSS JOIN Departments