title: Joining same column from same table multiple times
body: <p>I need a two retrieve data from the same table but divided in different columns.</p>
  
  <p>First table "<strong>PRODUCTS</strong>" has the following columns:</p>
  
  <ul>
  <li>PROD_ID</li>
  <li>PRO_TYPE_ID</li>
  <li>PRO_COLOR_ID</li>
  <li>PRO_WEIGHT_ID</li>
  <li>PRO_PRICE_RANGE_ID</li>
  </ul>
  
  <p>Second table "<strong>COUNTRY_TRANSLATIONS</strong>" has the following columns:</p>
  
  <ul>
  <li>ATTRIBUTE_ID</li>
  <li>ATT_LANGUAGE_ID</li>
  <li>ATT_TEXT_ID</li>
  </ul>
  
  <p>Third and last table "<strong>TEXT_TRANSLATIONS</strong>" has the following columns:</p>
  
  <ul>
  <li>TRANS_TEXT_ID</li>
  <li>TRA_TEXT</li>
  </ul>
  
  <p>PRO_TYPE_ID, PRO_COLOR_ID, PRO_WEIGHT_ID and PRO_PRICE_RANGE_ID are all integers and are found back in the column ATTRIBUTE_ID multiple times (depending on howmany translations are available). Then ATT_TEXT_ID is joined with TRANS_TEXT_ID from the TEXT_TRANSLATIONS table.</p>
  
  <p>Basically I need to run a query so I can retreive information from TEXT_TRANSLATIONS multiple times. Right now I get an error saying that the correlation is not unique.</p>
  
  <p>The data is available in more then 20 languages, therefore the need to work with intergers for each of the attributes.</p>
  
  <p>Any suggestion on how I should build up the query? Thank you.</p>