function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ 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

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