title: Unknown column 'i.email' in 'where clause'
body: <p>I try to execute my sql query but it seems something is wrong with it, can anyone correct it please.</p>
  
  <pre><code>SELECT * FROM (
   (SELECT i.email AS internautemail, i.compteEMVclient, i.datecreation FROM internaute i INNER JOIN lead lap ON i.id=lap.idInternaute)
     UNION
   (SELECT v.email AS usermail, v.compteEMVclient, v.datecreation FROM V2_user v INNER JOIN v2_lead vlap ON v.id=vlap.idUser)
   ) AS t
   WHERE i.compteEMVclient!=v.compteEMVclient
  </code></pre>