title: Big query inner join with 'like' clause
body: <p>I have two tables in big query below is an image representation of each\</p>
  
  <p><a href="https://i.stack.imgur.com/Z8wwH.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Z8wwH.jpg" alt="enter image description here"></a></p>
  
  <p>What i want is to sum the number of clicks by grouping the appropriate Land URLs. Below is the query I am using but it is not returning any result</p>
  
  <pre><code>Select a.quarters as Quarters, sum(b.clicks) as Clicks
  from `spreadsheetapi-1147.FlosportsDatabase.GroupByColumnReference` as a 
  inner join `spreadsheetapi-1147.FlosportsDatabase.kenshoo` as b 
  on lower(a.quarters) like concat('%' , b.land_url , '%' )
  group by a.quarters
  </code></pre>