soql passed through dbamp to salesforce using openquery syntax selects from Contact and includes select from child table. See query below.
For the ID specified in the query there are 13 records in the child table which match that ID. Only 2 records are returned.
Would like to know why. Is this a DBAmp bug? I did just install the latest DBAmp version. 22.0.8991.0
Any other possible explanation?
SELECT * FROM OPENQUERY(SALESFORCE, ' SELECT ID, Email, CLSA_Date_Completed__c, Client_Identifies_Race__c, Latino_Hispanic__c, ExpECM__Race__c, Religious_Spiritual_Affiliation__c,
ExpECM__Preferred_Language__c, Secondary_Language_Spoken__c, SACWIS_Case_ID__c, SACWIS_Person_ID__c, Primary_Insurance_Company_HMO__c, npe01__HomeEmail__c,Preferred_Method_of_Contact__c,
Primary_Policy_including_MA__c,
Primary_Phone__c, Primary_Phone_is_Mobile__c, Secondary_Phone__c, Secondary_Phone_is_Mobile__c
, (SELECT ExpECM__Main_Client__c, Name FROM ExpECM__Case_Records__r)
FROM Contact
WHERE ID = ''0031U00001MH3tSQAT''
')
