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%’)

Print Friendly, PDF & Email
This entry was posted in Development, Soql and tagged , . Bookmark the permalink.