+ Start a Discussion
meet.sivameet.siva 

Soql query

Hi,

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?

 

Regards

S.Sivakumar

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?

anup

Anup
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.