So I have two tables. One is client that looks like this
+----------+-----------+----------+-------------+--------+---------+---------+----------------+------------+-------+---------+
| ClientId | FirstName | LastName | DateOfBirth | Gender | PriLang | SecLang | Address | City | State | ZipCode |
+----------+-----------+----------+-------------+--------+---------+---------+----------------+------------+-------+---------+
| 00002 | Peter | Parker | 2001-08-10 | Male | 4 | 1 | 2389 Some Road | Where City | MA | 60042 |
+----------+-----------+----------+-------------+--------+---------+---------+----------------+------------+-------+---------+
And the other is language
+-------------------+-----------------+
| LanguageId | LanguageName |
+-------------------+-----------------+
| 1 | English |
| 2 | Spanish |
| 3 | Vietnamese |
| 4 | French |
| 5 | Korean |
| 6 | Japanese |
| 7 | Italian |
+-------------------+-----------------+
I cannot figure out how to replace the foreign key values in PriLang and SecLang with the Language names from the language table.