Subject SQL Creation question
Author

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