SQLite
Cross join is used to match every rows of the first table with every rows of the second table. If the first table contains x columns
and second table contains y columns then the resultant Cross join table will contain the x*y
columns.SELECT ... FROM table1 CROSS JOIN table2