Normally your application would be set up with a relationship where one customer has many customer sales. Simply look up the value of the country code from the customer table down to the sales table.
------------------------------ Mark Shnier (YQC) mark.shnier@gmail.com ------------------------------