what is cross join in sql and why we need this code example

Example: sql cross join

SELECT * 
FROM table1 
CROSS JOIN table2;