Make table that has every combination of OriginCountry and DestinationCountry
Posted on 2016-08-16
I have a table "AccountNumbers" In this table there a 4 fields, ID, OriginCountry, DestinationCountry, AccountNumber
I also have a table of Countries with 95 records (all the countries)
I need to populate the fields OriginCountry and DestinationCountry in table AccountNumbers with every possible combination of Country to Country. Number of records when completed should be 38025 (195 * 195)
What method should I use to accomplish this?