SQL JOIN
Cross Join:
Cross join combine each row from the first table with all rows of the second table.
In other words, it performs a multiplication between tables.
Cross join is also known as Cartesian Join.
Syntax:
select column_name(s)
from table1
cross join table2
We can perform cross join without join clause.

SQL JOIN
Outer Join:
Outer join returns all rows from one table and matching rows from second table.
There are three types of Outer join:
1) Left Outer Join
2) Right Outer Join
3) Full Outer Join
Syntax:
select column_name(s)
from table_name1
left | right | full [outer] join table_name2
on table_name1. column_name= table_name2. column_name
Left Outer

SQL JOIN
Sql join is used to combine data from two or more tables in a database.
Join keyword is used to join one (self-table) or more tables in sql query.
According to ANSI SQL-89 syntax for joining two tables:
select [column-list]
from table_name1,table_name2
where <where predicate>
According to ANSI SQL-92 syntax