[ https://issues.jboss.org/browse/TEIID-2625?page=com.atlassian.jira.plugin... ] Jeff Hayes updated TEIID-2625: ------------------------------ Description: The second part of the join criteria (and CHORUS_J0.userid = CHORUS_B.evtuserid) appears to be getting ignored. The result has same results as when only the first criteria (CHORUS_J0.sysid = cx2.sysid) is provided. Same query works are 8.1 with query plan listing both criteria in joinNode however for 7.7 only shows first criteria. Please see attached query plan. Is there a fix for this or workaround for the query? Thanks! Jeff was: The second part of the join criteria (and CHORUS_J0.userid = CHORUS_B.evtuserid) appears to be getting ignored. The result has same results as when only the first criteria (CHORUS_J0.sysid = cx2.sysid) is provided. Same query works are 8.1 with query plan listing both criteria in joinNode however for 7.7 only shows first criteria. Please see attached query plan. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira