Skip to main content
Topics#ApexFrage von Srikanta Mohapatra
Srikanta Mohapatra (LTM) fragte in #Apex
16. Juni 2017, 07:18

query join with criteria matching 2 different custom objects

Hi I have 2 different custom objects with field values same in both objects and wanted to query matching records. Also wanted to query records from both objects.

in sql I write like this

(SELECT Ord.OrderID__c, Cust.CustomerName__c, Ord.OrderDate__c

FROM Orders__c  Ord

INNER JOIN Customers__c  cust

ON Ord.CustomerID__c=Cust.CustomerID__c)

Please let me know how can I write in soql.

thanks in advance.
2 Antworten
  1. Waqar Hussain (Einsteam)
    16. Juni 2017, 07:51
    Salesforce does not support these type of queries. You have to use map and set and have to query separately each object.

    See below URLs.

    https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_methods_system_map.htm

    https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_methods_system_set.htm

    https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_methods_system_list.htm
Antwort schreiben...
0/9000