```C# var results = session .CreateQuery("select o.Employee.FirstName, o from Order o join fetch o.Customer") .SetMaxResults(1) .UniqueResult<object[]>(); ``` The query above leads to duplicated column aliases for fetched Customer ID: ```sql SELECT employee2_.FirstName AS col_0_0_ ,order0_.OrderId AS col_1_0_ ,customer1_.CustomerId AS customerid1_0_1_ -- <-HERE ,order0_.OrderId AS orderid1_3_0_ ,customer1_.CustomerId AS customerid1_0_1_ -- <-AND HERE ... ``` And that doesn't work on Oracle (for queries with paging) and SQL Server CE, SQL Anywhere. Related issue: https://nhibernate.jira.com/browse/NH-1773