[ https://issues.jboss.org/browse/TEIID-5860?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-5860: ---------------------------------- Description: In this query {code} SELECT originalLicense.Id,originalLicense.Status__c,originalLicense.ReplacementLicenseID__c,originalLicense.LicenseId__c,originalLicense.vlic_Contract_Number__c,replacementLicense.LicenseId__c as replacementLicenseId ,replacementLicense.LicenseId__c as replacementLicenseLicenseId FROM Product_License__c originalLicense LEFT OUTER JOIN /*+ MAKEDEP */ Product_License__c replacementLicense ON originalLicense.ReplacementLicenseID__c = replacementLicense.Id where originalLicense.vlic_Contract_Number__c = :contractNumber {code} We have two requests to salesforce, but could generate a single SOQL query. was: In this query {code} SELECT originalLicense.Id,originalLicense.Status__c,originalLicense.ReplacementLicenseID__c,originalLicense.LicenseId__c,originalLicense.vlic_Contract_Number__c,replacementLicense.LicenseId__c as replacementLicenseId ,replacementLicense.LicenseId__c as replacementLicenseLicenseId FROM Product_License__c originalLicense LEFT OUTER JOIN /*+ MAKEDEP */ Product_License__c replacementLicense ON originalLicense.ReplacementLicenseID__c = replacementLicense.Id where originalLicense.vlic_Contract_Number__c = :contractNumber {code} We have wrong two requests to salesforce but need one. Fix Version/s: 13.1 Summary: Salesforce translator should support self joins (was: Need to properly generate SOQL for self joins) -- This message was sent by Atlassian Jira (v7.13.8#713008)