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

Soql query


I have two custom objects Opportunity_CRM__c and Test__c. Each custom fields in Test__c is populated using data from Opportunity_CRM__c based on some conditions.

There is no relationship between the two custom objects.


For example:


Total_Opportunities field in Test__c takes total count of opportunities from Opportunity_CRM__c and Total_Opportunities_Closed_Won field in Test__c takes total count of closed won opportunities from Opportunity_CRM__c.


All fields are grouped based on employee_ID__c field.


Is there any way to write Soql sub query?




Anup JadhavAnup Jadhav
what do you mean by soql sub query? If they are not linked/related you can't write join queries.

What do you want to achieve with the query?


ForceMantis (Amit Jain)ForceMantis (Amit Jain)

You cannot right sub-query as there is no relationship.


Although you can query data from both object and initialize Map to locate and use records without hitting governor limits.