How do you do a union of two tables in NHibernate?

hql, nhibernate

Solution

Found my answer:

http://www.hibernate.org/117.html#A21

It doesn't currently support union or intersect.

Problem

I need to do a union of two tables using NHibernate and HQL. I have found very little help online, and I want to know if it is possible and if so how?

Original source