Select * from group, supplier
Norbert Saint Georges TetraSys Oy Bergantie 69, FI-02540 Kylmälä Tel. : +358 (0) 400 27 25 18 E- mail : [email protected] <mailto:[email protected]> De : [email protected] [mailto:[email protected]] Envoyé : mercredi 1 avril 2015 12:18 À : [email protected] 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
