Question

Difference between cartesian product and natural join

Answer 1

Cross joins creates all possible pairing of rows from two tables whether they match or not.

Natural join is like an inner join,but it assumes the condition is equality and applies for all columns names.