Hi ,
I need help creating a join betwwen two tables in the HQl query.
I have one table TableA and other TableB both have a column dealid common.In first table this is a primary key but in the second table though this column is there but I have not put a foreign key constraint for this particular column. I'm writing a query like this




Are there additional attributes that's needs to be added in the class files for these two table or something else have to be done. I know it's a simple thing but some how I'm not able to make the join and get the Data.Plz if possible tell me all the steps or give me a link as to how to make joins.