7 Replies Latest reply: Jun 21, 2012 10:35 AM by gerardo.pauza RSS

    <> condition issue

      Hi everyone,

            i have a problem with the condition <> in a count expression.


      The expresion is this:

      count(distinct(if(USERS_ALL.u_email <> SUBSCRIPTIONS_DISTINCT.email, USERS_ALL.u_email)))


      and for example, in both tables there is a value like 'gerardo@hotmail.com' but i dont know why the last expression include this value.


      What im doing wrong?