Hi, I have several combinations and I want to get all the possible combinations between them.
For example (note, this is not the tables i'm working with, it's just for giving an example):
SELECT weekday, seasons FROM weekdays CROSS JOIN seasons
would return
monday spring
monday summer
monday fall
...
tuesday spring
tuesday summer
...
sunday winter
With CROSS JOIN I get all possible combinations but always using a record from each table.
I want to get something like this:
null spring
null summer
...
monday null
monday spring
monday summer
...
tuesday null
tuesday spring
...
sunday winter
Please help me, it's urgent