What is the difference between cross join and natural join?

NATURAL JOIN

CROSS JOIN

Natural Join joins two tables based on same attribute name and datatypes.

Cross Join will produce cross or cartesian product of two tables 

In Natural Join, The resulting table will contain all the attributes of both the tables but keep only one copy of each common column

In Cross Join, The resulting table will contain all the attribute of both the tables including duplicate columns also

In Natural Join, If there is no condition specifies then it returns the rows based on the common column

In Cross Join, If there is no condition specifies then it returns all possible pairing of rows from both the tables whether they are matched or unmatched

SYNTAX:

SELECT * FROM table1 NATURAL JOIN table2;

SYNTAX:

SELECT * FROM table1 CROSS JOIN table2;