4 Replies Latest reply: Jun 3, 2016 3:41 AM by Evgeny Stuchalkin RSS

    how to make 'where not exist' in mysql syntax?

    Evgeny Stuchalkin

      Hello everyone! I'm trying to load data from mysql table with this condition:


      FROM `amo.demo`.contacts where not exists (tsKey,`i_companyID`&'|'&`s_responsibleUser`&'|'&`i_contactID`&'|'&null());


      And keep getting message about wrong syntax for mysql. What syntax is correct in this situation?