How is a cross join different from natural join? Give example.

Q. How is a cross join different from natural join? Give example.

Answer:-

Cross Join: - A form of join that produces all possible combinations of row from two tables.
Example:-
Select * from School CROSS JOIN Student;

Natural Join: - A join where identical column from both tables is shown just one in the result.
Example:-
Select * from Student Natural Join School;