Hi All,

In database when we joins table using like below
SELECT t1.name, t2.salary
FROM employee AS t1 INNER JOIN info AS t2 ON t1.name = t2.name;

how can we do the same thing using hibernate.

any help will be appreciated

Thanks in advance

You need to define a relationship between your class Employee and your class Info.
You won't be able to join the 2 tables if they are not linked in the hibernate mapping.
For example you can define a property named info of type Info in the class Employee (one-to-one relationship).
Then you can make a request like this:

select emp.name, emp.info.salary from Employee as emp

thanks overmeulen. It worked

Actually, you can make (cross) joins in HQL, which are useful if you don't have explicit relationships defined:

Indeed you can use cross joins but this is not the best choice if you take performance into account ...