title: SQL - Getting a column from another table to join this query
body: <p>I've got the code below which displays the <code>location_id</code> and total number of antisocial crimes but I would like to get the <code>location_name</code> from a different table called <code>location_dim</code> be output as well. I tried to find a way to <code>UNION</code> it but couldn't get it to work. Any ideas?</p>
  
  <pre><code>SELECT fk5_location_id , COUNT(fk3_crime_id) as TOTAL_ANTISOCIAL_CRIMES
  from CRIME_FACT
  WHERE fk1_time_id = 3 AND fk3_crime_id = 1 
  GROUP BY fk5_location_id;
  </code></pre>