+ Start a Discussion
ranirani 

Joins in sForce Explorer 8.0

Hi All,
 
I have custom object "abc__c" in which there is a field name "Account__c" which stores Account Id. I want to get results from object name "Account" and "abc__c" where "Accoun.SystemMobStamp >= some date or abc__c.SystemMobStamp >= some date". The query in SQL would like:
 
Select
Account.Id, abc__c.Account__c
Where
Account.Id = abc__c.Account__c and
(Account.SystemMobStamp >= some date or abc__c.SystemModStamp >= some date)
 
Can some one provide a equalent statement for above in Sales Force (SOQL).
 
Help is appreciated.
 
Regards,
Rani