You need to sign in to do that
Don't have an account?
kabu
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.
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.
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