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
Deepakn12Deepakn12 

SOQL issue

I am hard time to write a SOQL for a particular requirement. I need to find parent records based on child record value. We can include child record field in select clause using sub query but i need to know how can use in where clause.
For example i need to get product based on opportunity name from product object.
Thx and regards,
Deepak.
SaaniaSaania
Check this doc, http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_calls_soql_relationships.htm, it might help understand creation of relationship queries.