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. 

Leave a Reply

Your email address will not be published.

*

clear formPost comment