[ https://issues.jboss.org/browse/TEIID-5856?page=com.atlassian.jira.plugin... ] Renat Eskenin commented on TEIID-5856: -------------------------------------- i'm sorry i used this ddl (xml is from logs generated vdb) {code} CREATE DATABASE db; USE DATABASE db; CREATE FOREIGN DATA WRAPPER salesforce; CREATE FOREIGN DATA WRAPPER mysalesforce type salesforce OPTIONS (supportsOrderBy true); CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS ("resource-name" 'salesforce'); CREATE SCHEMA sf SERVER salesforce; IMPORT FROM SERVER salesforce INTO sf OPTIONS("importer.useFullSchemaName" 'false', "importer.NormalizeNames" 'false', "import.modelAuditFields" 'true', "import.importStatstics" 'true'); {code} in SYS.tables i have {code:json} { "Cardinality": -1, "NameInSource": "Product_License__c", "Name": "Product_License__c", "UID": "tid:000005adccd6-9897fe32-00000545", "Type": "Table", "IsPhysical": true, "SupportsUpdates": true, "IsMaterialized": false, "VDBName": "db", "IsSystem": false, "SchemaUID": "tid:000005adccd6-00000e53-00000000", "SchemaName": "sf" } {code} It is true information about dependencies? Why this way do not working? This variant of solution working fine {code:sql} SELECT originalLicense.Id,originalLicense.Status__c,originalLicense.ReplacementLicenseID__c,originalLicense.LicenseId__c,originalLicense.vlic_Contract_Number__c,replacementLicense.LicenseId__c as replacementLicenseId ,replacementLicense.Id as replacementLicenseObjectId FROM Product_License__c originalLicense LEFT OUTER JOIN OPTION /*+ MAKEDEP */ Product_License__c Product_License__c replacementLicense ON originalLicense.ReplacementLicenseID__c = replacementLicense.Id where originalLicense.vlic_Contract_Number__c = :contractNumber {code} -- This message was sent by Atlassian Jira (v7.13.8#713008)