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.

One thing to note is that the same query on 7.7 works when the databases
are on DB2 (using DB2 translator) but not when they are on Datacom (different translator). Is this possibly a translator issue maybe not being able to support multiple join criteria?

8/15: Confirmed the problem occurs for both DB2 and Datacom translators.

Any advice would be appreciated as this is affected a customer installation.

Thanks!
Jeff