subqueries are not supported anywhere other than where and select clauses of querycommands ------------------------------------------------------------------------------------------ Key: TEIID-82 URL: https://jira.jboss.org/jira/browse/TEIID-82 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 6.x Reporter: Steven Hawkins Fix For: 6.1.0 Defect Tracker #23760: Subqueries in other place, for example, delete, update, and procedure if statements, and join criteria do not support subqueries in criteria. If this cannot be worked for 5.6, then validations should be added so that invalid subqueries are detected.