Subject | RE: [firebird-support] SQL Creation question |
---|---|
Author | Norbert Saint Georges |
Post date | 2015-04-01T10:17:49Z |
Select * from group, supplier
Norbert Saint Georges
TetraSys Oy
Bergantie 69, FI-02540 Kylmälä
Tel. : +358 (0) 400 27 25 18
E- mail : nsg@...
De : firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Envoyé : mercredi 1 avril 2015 12:18
À : firebird-support@yahoogroups.com
Objet : [firebird-support] SQL Creation question
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