Hi, Yesterday I was writing a query which used an innerjoin on two tables. I properly defined the aliases on both my queries, but on running the query I kept on getting an Oracle error that a column was ambiguously defined. Looking at the actual query that ES outputs to Oracle I saw that the join aliases are not being put in front of ...