Subject RE: [firebird-support] SQL Creation question
Author Norbert Saint Georges

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