Select and Replace Column Values With Data From Another Table
<p>I have tables set up like so:</p>

<pre>
Fruits:
ID | Name
---+-----
 1 | Apple
 2 | Orange
 3 | Banana
 4 | Lemon</pre>

<p>and</p>

<pre>
Groups
ID | Name | Fruit1 | Fruit2 | Fruit3
---+------+--------+--------+-------
 1 |   A  |    1   |    2   |    3
 2 |   B  |    1   |    3   |  NULL
 3 |   C  |    4   |  NULL  |  NULL 
</pre>

<p>What I'd like is to select from Groups and get the fruit name rather than its id like so:</p>

<pre>
ID | Name | Fruit1 | Fruit2 | Fruit3
---+------+--------+--------+-------
 1 |   A  | Apple  | Orange | Banana
 2 |   B  | Apple  | Banana |  NULL
 3 |   C  | Lemon  |  NULL  |  NULL 
</pre>

<p>Can this be done?</p>

<p>Thanks in advance.</p>