The CROSSJOIN function creates table, showing all possible combinations of values from two other tables.

For example from these two tables:

you can create a third table, showing all combinations – to merge everything with everything.