Microsoft.NET Framework 3.5
Select distinct T.ID, T.Name from T
inner join T2 on T.ID = T2.TID
order by T.Name
With this native query (using ISQLQuery) and the statement "DISTINCT" is necessary because the union wiht T2 produces duplicate results of T.
if I use
It generates the following Query
first results are generated with ROW_NUMER, for example
Then "DISTINCT" no longer makes sense, because all records are different due to ROW_NUMBER.
In version 2.0.1 GA works perfectly