title: SQL: is where name like %columnName% possible
body: <p>I am aware of using where and like this </p>
  
  <pre><code>select * from Table1
  join table2
  on table1.column like %text%
  </code></pre>
  
  <p>i want to extend the same logic to the column. i.e</p>
  
  <pre><code>select * from Table1
  join table2
  on table1.column like %table2.column%
  </code></pre>
  
  <p>This is impossible on SQL? is there an alternative for this?</p>
  
  <p>Thanks</p>