SQL FULL OUTER JOIN Keyword

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.

SQL full outer 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;          

					

SQL CROSS JOIN

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:
  1. Using the JOIN syntax.
  2. the table in the FROM clause without using a WHERE clause.
SYNTAX of SQL CROSS JOIN: SELECT * FROM [TABLE1] CROSS JOIN [TABLE2]

or

SELECT * FROM [ TABLE1] , [TABLE2] SQL Statement: SELECT * FROM MatchScore CROSS JOIN Departments