title: MYSQL join a table which its name is stored as a field value on another table
body: <p>I am trying to build a dynamic query in MYSQL to join a table which its name is stored as a field value on another table like this :</p>
  
  <pre><code>SELECT * FROM CATEGORIES 
  INNER JOIN CATEGORISATIONS ON CATEGORISATIONS.id = CATEGORIES.fk_categorisation
  INNER JOIN [CATEGORISATIONS.nom_table] LV_REGIONS ON LV_REGIONS.id = CATEGORIES.valeur
  </code></pre>
  
  <p>Any answer?!</p>