title: Which type of join to use?
body: <p>I have a table called PROJECT_CATEGORY and it contains two fields</p>
  
  <p>cat_id and cat_title</p>
  
  <p>I am storing the cat_id in another table called PROJECTS so:</p>
  
  <pre><code>project_category.cat_id = projects.cat_id
  </code></pre>
  
  <p>What is the best way using MySQL to run a query to show the <code>cat_title</code>. In other words I want to display the name not the ID number of the table. Would this work:</p>
  
  <pre><code>SELECT * FROM projects INNER JOIN projects ON project_category.cat_id = projects.cat_id
  </code></pre>
  
  <p>Then call it:</p>
  
  <pre><code>'.$row['cat_title'].'
  </code></pre>
  
  <p>Any thoughts?</p>