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