title: Database lookup for each value of another database lookup
body: <p>I am not sure how to exactly word this as I have just started SQL and have just finished going over simple joins.</p>
  
  <p>Ill start with my tables first:</p>
  
  <p>tblQuestions
  <PRE>
  | Survey ID | User ID | Entry Date | Question 1 | Question 2 | Question 3 | Question 4 |
  |     1     |   305   |    date    |      0     |      1     |     2      |      3     | 
  </PRE></p>
  
  <p>tblValues
  <PRE>
  |  VID  | TextValue |
  |   0   |   Never   |
  |   1   |   Rarely  |
  |   2   | Sometimes |
  |   3   |   Often   |
  </PRE></p>
  
  <p>I want an SQL query that outputs the TextValues of each questions VID.
  I can't store the text values directly because the data will be exported for charts. Also I from what I understand repetitive data is bad table design and rule for when to normalize tables.</p>
  
  <p>Is this possible through a single query?</p>
  
  <p>EDIT: I am using MS Access.
  Desired output:</p>
  
  <p><PRE>
  | Survey ID | User ID | Entry Date | Question 1 | Question 2 | Question 3 | Question 4 |
  |     1     |   305   |    date    |    Never   |   Rarely   |  Sometimes |    Often   | 
  </PRE></p>