8 Replies Latest reply: Dec 18, 2014 2:11 PM by Robert Hutchings RSS

    WHERE EXISTS OR SQL SELECT

      The statement below loads Contacts where the ContactID already exists AND where the Inactive_contact__c field is FALSE.

       

       

      How can I amend it so that I load Contacts where the ContactID already exists OR where the Inactive_contact__c field is FALSE?

       

       

      Contacts:

      LOAD Id as ContactId,

          AccountId,

          Email,

          Phone,

          Inactive_Contact__c,

          Name

        WHERE EXISTS(ContactId,Id);

      SQL SELECT *

      FROM Contact

      WHERE AccountId != NULL AND Inactive_Contact__c=FALSE;