Please describe how a cross join (also known as the Cartesian PRODUCT) works.
A cross join is when we join every row of one table to every row of another table, which yields all possible pairs. Note A cross join can be specified in two ways: using the JOIN syntax or by listing the tables in the FROM clause separated by commas without using a WHERE clause to supply join criteria.