3586513 - Task failed with error: "Table for column does not occur in the FROM clause" - SAP Cloud Integration for data services

• Task fails with error
• RES-20139 |STATEMENT <GUID::'xxx-x wwuodBO0w' QUERY xxx> Table <xxx> for column <xxx> does not occur in the FROM clause. For a top-level query, all columns must belong to some table in the FROM clause.
• When validating the task, it has error: "The join condition uses an invalid reference of table <xxx.xxx>. Only table names from the current join pair and its preceding join pairs can"

SAP Cloud Integration for Data Services

CI-DS, Task Failure, Validation Error, Join Conditions, Transform, query, FROM clause, Join Pairs, RES-20139, invalid reference , KBA , LOD-HCI-DS , HANA Cloud Integration for Data Services , Problem