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
Daniel KDaniel K 

Change subquery to normal query

Hi All,
          I have a subquery which I want to change to normal query:

SELECT Field1, Field2, (SELECT Name, Identifier__c FROM childObject__r Where type='some value') FROM Contact

          Can I know how can I do that ?

Thanks
MagulanDuraipandianMagulanDuraipandian
Try this
SELECT Name, Identifier__c, Contact__r.Field1, Contact__r.Field2 FROM ChildObject__c

--
Magulan Duraipandian
www.infallibletechie.com