|Subject||SQL Creation question|
I have two tables.
They are not related in anyway.
One table contains groups and the other contains suppliers
Lets say they have this content
Can I create a SELECT statement, which will return every combination of the two tabels?
Here it should be:
Group 1, Supplier 1
Group 1, Supplier 2
Group 2, Supplier 1
Group 2, Supplier 2