title: Left join with string function?
body: <p>I need to left join two tables:</p>
  
  <ul>
  <li>One table has emails</li>
  <li>The other table, is a domain blacklist.</li>
  </ul>
  
  <p>I did something like this:</p>
  
  <pre><code>SELECT
     CASE 
        WHEN b.domain IS NULL then "Invalid"
        ELSE "Valid"
     END as Validated
  FROM Emails e
  LEFT JOIN DomainBlacklist b
  ON ENDS_WITH(LOWER(e.email), LOWER(b.domain))
  </code></pre>
  
  <p>But throws me an error:</p>
  
  <p>"LEFT OUTER JOIN cannot be used without a condition that is an equality of fields from both sides of the join." </p>
  
  <p>Someone know how can I solve this?</p>
  
  <p>Thanks!</p>