[ https://issues.jboss.org/browse/TEIID-3039?page=com.atlassian.jira.plugin... ] Ramesh Reddy edited comment on TEIID-3039 at 5/6/15 3:29 PM: ------------------------------------------------------------- {code} http://host/service/Customers?$expand=Orders($filter=$it/Address/City eq ShipTo/City) {code} becomes {code} customers left outer join orders on (customers.pkey = orders.fkey and (select city from address where address.fkey = customers.pkey) = (select city from shipTo where shipTo.pkey = address.fkey)) {code} was (Author: rareddy): {code} http://host/service/Customers?$expand=Orders($filter=$it/Address/City eq ShipTo/City) {code} becomes {code} customers left outer join orders on (customers.pkey = orders.fkey and (select city from address where address.fkey = customers.pkey) = (select city from shipTo where shipTo.pkey = address.fkey)) {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)