title: how to use a like with a join in sql?
body: <p>I have 2 tables, say table A and table B and I want to perform a join, but the matching condition has to be where a column from A 'is like' a column from B meaning that anything can come before or after the column in B:</p>
  
  <p>for example: if the column in A is 'foo'.  Then the join would match if column in B is either: 'fooblah', 'somethingfooblah', or just 'foo'.  I know how to use the wildcards in a standard like statement, but am confused when doing a join.  Does this make sense? Thanks.</p>