title: Yii, get value from other table with foreign key
body: <p>I'm prety new to yii framework so i could use some help with something.
  Lets say i got a table in my database with users, 1 of the profile fields is nationality.
  In another table i got a lot of nationalities like this:</p>
  
  <pre><code> id    Nationality    short
    1    Germany         DE
    2    France          FR
    3    Netherlands     NL
  </code></pre>
  
  <p>etc... about 60+ nationalities.
  In the usertable, the user nationality is linked with this table, like this:</p>
  
  <pre><code>id    username    nationality
  1      user            1
  </code></pre>
  
  <p>that means the nationality of user 1 = germany. but how can i select germany from the nationalities table when im in the profile view?</p>
  
  <p>i hope im clear, else ask :)</p>
  
  <p>greets,
  stefan.</p>