Avatar of ExpressMan1
Flag for Canada

asked on 

Make table that has every combination of OriginCountry and DestinationCountry

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?
DatabasesMicrosoft SQL ServerSQL

Avatar of undefined
Last Comment
Sharath S

8/22/2022 - Mon