title: How to like two columns in one SQL statement
body: <p>How to write this SQL?</p>
  
  <pre><code>Table A Column aa
  -----
  jack
  jim
  alan
  
  Table B Column bb
  -----
  jacky
  jimmy
  william
  </code></pre>
  
  <p>The output is:</p>
  
  <pre><code>-----
  jack jacky
  jim jimmy
  </code></pre>
  
  <p>Because aa's value is bb's substring. </p>