Hi,

I only want to make an easy inner join of two tables, but I don't get it work.

Here is the SQL query:

SELECT *
FROM dbo.team INNER JOIN
dbo.statistik ON dbo.team.TeamID = dbo.statistik.TeamID

Table team is mapped in class Team and table statistik in class Statistik.
I tried to get it work with NHibernate, but I always get an error.

HQL:

return session.CreateQuery(@"SELECT * FROM Statistik INNER JOIN Team ON Statistik.TeamID = Team.TeamID").List();

I also tried it with CreateSQLQuery and with CreateCriteria, but it's always the same ... error.

Did somebody has an idea, how I could solve this problem?

regards,
Tribjun

You can try using

return session.CreateSQLQueryQuery(@"SELECT * FROM Statistik INNER JOIN Team ON Statistik.TeamID = Team.TeamID").List();

hope this works for you

regards
Selva

Hi Selva,

sadly it doesn't work. The following message occurs:

"Return types of SQL query were not specified ..."

That's why I guess it must exist a solution with CreateQuery or with CreateCriteria ... but how?