Subject | SQL Creation question |
---|---|
Author | |
Post date | 2015-04-01T09:18:05Z |
Hi
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
GROUP
=====
Group 1
Group 2
SUPPLIER
========
Supplier 1
Supplier 2
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
Regards
Michael