[teiid-issues] [JBoss JIRA] Resolved: (TEIID-1097) Add support for nested table references

Add support for nested table references --------------------------------------- Key: TEIID-1097 URL: https://jira.jboss.org/browse/TEIID-1097 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.0 Reporter: Steve Hawkins Assignee: Steve Hawkins Fix For: 7.0 Our current approach to procedural relational queries that relies upon criteria is difficult to use and causes numerous problems, such as TEIID-32 and unclear applicability of default values. It would be easier to just add support nested table references. e.g. select * from t, table(... t.x) t1 Where the join between the procedure or query contained in the table expression is implied. See http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/c... for more on the usage constraints. This functionality is also needed by the XMLTABLE function.