You need to sign in to do that
Don't have an account?
Raksha Narayan
SOQL query on non-related objects
Account is a parent to Object B and Object C. Object B and Object C does not have any relationship. From Object B I want to find Object C's fields(like name etc.,) using Account in a single SOQL query. Can this be achieved?
https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/langCon_apex_SOQL.htm
https://www.salesforcetutorial.com/soql-inner-join-outer-join-relationships-salesforce/
Thanks,
Here is the query I was trying.
select id,Account.Name from ObjB where Account.Name IN(select Account__c from ObjC). In the inner query I am passing the Account__c, but I want to find the value of Name field from ObjC. Is this achievable in any way?