title: Join count as a column in the sql query
body: <p>I have two tables Business and BusinessCat. I need a MSSQL Query that will get me the following result:</p>
  
  <pre><code>ID | CategoryName | RecordCount
  1  | Local        | 3
  2  | National     | 1
  3  | International| 2
  4  | Other        | 0
  </code></pre>
  
  <p>I need the count of how many there are in each category as another column. </p>
  
  <p>Business table looks like this:</p>
  
  <pre><code>ID | Category | BusinessName
  1  | 3        | Blackstone, Inc.
  2  | 2        | Pet Smart
  3  | 1        | John Doe
  4  | 3        | Best Buy
  5  | 1        | Sams Treats
  6  | 1        | Eastcoast Tattoo
  </code></pre>
  
  <p>BusinessCat table looks like this:</p>
  
  <pre><code>ID | CategoryName
  1  | Local
  2  | National
  3  | International
  4  | Other
  </code></pre>