Hi Experts,

Consider database table is "e_table". It contains the fields are "e_id" and "e_name".

my question is:

How to retrieve and display the values when the same table is act as another table to retrieve the values like the following query.

"SELECT e1.*,e2.* FROM e_table e1,e_table e2;".

When i using the above query i got the answer in sql.

When i implementing in to hibernate it retrieves only the first renamed field but it does not retrieve second renamed field.

Any suggestion would be appreciated.
Thanks . . .