Error with Salesforce translator if criteria on outer join on a custom table is from the right side table ---------------------------------------------------------------------------------------------------------- Key: TEIID-4947 URL: https://issues.jboss.org/browse/TEIID-4947 Project: Teiid Issue Type: Bug Components: Salesforce Connector Affects Versions: 8.7.11.6_2, 8.12.10.6_3 Reporter: Debbie Steigner Assignee: Steven Hawkins Fix For: 10.0, 9.3.1 Running a left outer join between a parent and child custom table in salesforce results in an error: select a.id, a.name, a.LastModifiedDate, b.Order_Recipe_Steps__c, b.name from MPRS_Salesforce.Media_Prep_Order_Recipe_Steps__c a left outer join "MPRS_Salesforce"."Recipe_Step_Detail__c" b on (a.id = b.Order_Recipe_Steps__c) where b.LastModifiedDate >= parsetimestamp('2016-05-04 15:01:03.0', 'yyyy-MM-dd hh:mm:ss.s') Error: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 MPRS_Salesforce: com.sforce.soap.partner.InvalidSObjectFault: INVALID_TYPE: Recipe_Step_Detail__c.Catalog_Item__c FROM Recipe_Step_Detail__cs) FROM Media_Prep_Order_Recipe_Steps__c ^ ERROR at Row:1:Column:1137 Didn't understand relationship 'Recipe_Step_Detail__cs' in FROM part of query call. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names. SQLState: 50000 ErrorCode: 30504