Tag Archives: WHERE IN

May 02

SOQL Where IN

Select Id, StageName, Reason_Lost__c FROM Opportunity WHERE Id IN ( ‘006a000000wfxFU’, ‘006a000000vUx61’, ‘006a000000vUx7J’, ‘006a000000vUx6k’, ‘006a000000wfxXf’, ‘0063000000qxm0w’, ‘0063000000t0xDP’, ‘006a000000yCxVe’, ‘006a000000yCXkp’, ‘0063000000lYXsI’, ‘006a000000yPXz2’, ‘0063000000pbXTg’ ) select Account.Id, Account.Name From Account WHERE Account.Id IN (select AccountId From Opportunity WHERE Name like ‘Test%’)

Posted in Development, Soql | Tagged , | Comments Off on SOQL Where IN