function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Shubham SengarShubham Sengar 

SOQL Problem 8

Show all the account IDs that have open opportunities if the last name of the contact associated with 

the account is like the last name “Apple”:??
Amit Chaudhary 8Amit Chaudhary 8
Please try below below query . I hope that will help u 
select Accountid from opportunity where StageName = 'Open' and Accountid in (select accountid from contact where lastName ='test')

Please let us know if this will help you

Thanks
Amit Chaudhary
 
Amit Chaudhary 8Amit Chaudhary 8
Please mark above as  best Anwser if that resolve your issue. SO that some one has same issue that poast can help other