title: Using AND in an INNER JOIN
body: <p>I am fairly new with SQL would like to understand the logic below.</p>
  
  <pre><code>SELECT *
  FROM Table A A1 
  INNER JOIN TABLE B B1 ON B1.ID = A1.ID AND A1 = 'TASK';
  </code></pre>
  
  <p>Not sure if this is a clear detail but please let me know. Thanks!</p>