Can anyone help me with inner joins. I am trying to build a query similar to below
SELECT s from School s, Address a where s.id=a.id
I am trying to fetch all those records from School table which has id number equal to the one in address table. I am trying to use inner jon and i am getting errors
The query I have built is
from School s inner join Address a with s.id=a.id
Please correct me if i am wrong. I have also set the mapping params in the .hbm.xml file