Table A:

ID
NAME
ACTIVE

TABLE B:
ID
A_ID (Foreign key referencing table A)



Table A
1 name1 T
2 name2 T
3 name3 T


Table B
100 1
101 1
102 2
103 3

HQL:

"from TableA a left join fetch a.TableB where a.active='T'"

This returns a list which has name1 repeated twice...

i want list of tableA objects and i should be able to navigate to each Table A' object's set to fetch Table B's objects

How do i modify the query to achieve that?

Right now, it returns 4 items in the list with item1 and item2 name being the same


Thank you