title: How to join two tables by multiple columns in SQL?
body: <p>I have two tables named <code>Evaluation</code> and <code>Value</code>.</p>
  <p>In both tables, there are four columns. But three of the four are the same. In other words, they both have the <code>CaseNum</code>, <code>FileNum</code>, <code>ActivityNum</code> columns. In addition to those, the <code>Evaluation</code> table has the <code>Grade</code> column, and the <code>Value</code> table has the <code>Score</code> column.</p>
  <p>I want to merge the two into one table, joining by <code>CaseNum</code>, <code>FileNum</code>, and <code>ActivityNum</code>, so I have a new table of five columns, including <code>Value</code> and <code>Score</code>.</p>
  <p>Can I use <code>INNER JOIN</code> multiple times to do this?</p>