title: Multiple columns with Foreign Key to the Same Table
body: <p>I have a "MENU" TABLE that has the following fields</p>
  
  <pre><code>MENU_ID, MENU_NAME
  </code></pre>
  
  <p>I have a "USER" TABLE that has the following fields</p>
  
  <pre><code>USER_ID, EXPLORER_MENU_ID, TABLET_MENU_ID
  </code></pre>
  
  <p>EXPLORER_MENU_ID and TABLET_MENU_ID are FOREIGN keys TO MENU TABLE.
  .
  How can i get the following information FROM these two tables?</p>
  
  <pre><code>USER_ID, EXPLORER_MENU_NAME, TABLET_MENU_NAME
  </code></pre>
  
  <p>I have tried JOINs and Union and I can get this info in two different output records, one for EXPLORER_MENU_NAME and one for TABLET_MENU_NAME but I want this info in one single record as this</p>
  
  <pre><code>USER_ID, EXPLORER_MENU_NAME, TABLET_MENU_NAME
  </code></pre>
  
  <p>Thanks for your help</p>