Suppose I have two tables. One consists of these columns: 'Friends' and some other information on my friends. The other table consists of a few columns that are the countries which my friends reside in. The 'Friends' column will have a list of my friends' names, while the country columns will each contain my friends residing there. How would I go about to sort the first table base on the 'Friends' column such that they will be grouped into which country they are from?



I am using Office 97 at my workplace.