Sql Question - Returning Multiple Rows As One Record

Hi,

In the process of localizing the 'regions' table, we added three new
tables. The localized data will be stored in the TokenKeys and
TokenValues tables. It would be easier if we did away with the
TokeyKeys/TokenValues tables and just added a localeid in the regions
table, but this is the desired schema by the client. Here's the
schema:

Table: regions
id nameabbreviation
1 United StatesUS

Table: locales
id locale
1 en_US
2 fr_CA

Table: TokenKeys
id key
1 db.regions.name
2 db.regions.abbreviation

Table: TokenValues
id keyid valuelocaleid
1 1 Etas Unis2
2 2 EU2


The old sql was simply this:
select name, abbreviation from regions

which returns:
United States, US

But the new sql needs to link in the localized data from the tokeykeys
and tokenvalues tables using the localeid... I�m trying to figure out
what the sql statement would look like to return this:
Etats Unis, EU (This is supposed to be the French version)

My confusion is we are trying to return multiple column values from
the same column (TokenValues.value) and make them act as separate
columns in the same record, like it was with the original.

Thanks