Hi all, I have a problem running a query (using session.CreateQuery) :
I have two tables T1 and T2.
T1 and T2 have no link mapped in nhibernate between them but I need to do a join between those two tables :
Code:
SELECT
T1.Field1,
T2.Field2
FROM
T1 LEFT JOIN T2 ON T1.Field3 = T2.Field3
Nothing is returned when executing "query.List()"
and looking at the log, I have this:
Code:
2005-07-12 14:43:17,125 [2720] DEBUG NHibernate.Impl.SessionImpl [] <> - opened session
2005-07-12 14:43:17,125 [2720] INFO NHibernate.Impl.SessionImpl [] <> - SQL Query: SELECT T1.Field1, T2.Field2 FROM T1 LEFT JOIN T2 ON T1.Field3 = T2.Field3
2005-07-12 14:43:17,140 [2720] DEBUG NHibernate.Impl.SessionImpl [] <> - closing session
Someone got an idea ?
Thx by advance
Login
FAQ
Search