Right now I am doing a simple project on hibernate. I have a simple question
I have two tables for example: TableA and TableB.
TableA has TableId and TableAName.
TableB has TableId, UserId and TableBScore.
Both TableIds are primary keys. Now I would like to retrieve TableAName, TableBScore based on UserId from TableB. I have a basic idea that how to write in SQL.
Select A.TableAName, B.TableBScore from TableA A,TableB B where A.TableId=B.TableB and B.UserId=1;
I was trying to do this using HQL I couldn't understand how to do this scenario. Can anyone help me in this?
You need to join both entities. As per your code, we are assuming that A.TableId=B.TableB are same. Means both tables have same primary key. So this is one to one mapping and you can use primaryKey join annotation to map both entity. In that case you need to pass userId only in find method for table B and you will get data from Table A also.
Make sure table B is the owner of the relationship.