title: Inner join with like clause
body: <p>I am using inner join with the like clause ..</p>
  
  <p>My tried sql is</p>
  
  <pre><code>SELECT tbl_songs.id    AS sid, 
         tbl_songs.name  AS sname, 
         tbl_albums.id   AS aid, 
         tbl_albums.name AS aname 
  FROM   tbl_songs 
         INNER JOIN tbl_albums 
                 ON tbl_songs.albums LIKE '%' + tbl_albums.name + '%'; 
  </code></pre>
  
  <p>Its showing me syntax error.</p>
  
  <pre><code>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+ tbl_albums.name + '%'' at line 2
  </code></pre>
  
  <p>Please elaborate reason of syntax error.</p>