Getting data for columns from different tables having same name

[Sham Phadtale]

Hello All,

I am facing a problem while using JPA.
I am using following code to get data from different tables for columns with same name -

String strQuery = "select a.hostname as Hostname, a.name as AName, a.Id as AId, c.name as CName from A a, B b, C c where a.Id = b.Id and b.TYPE_ID=c.TYPE_ID and b.modID="+modId;
Query q = entityManager.createNamedQuery(strQuery); 
List<Object[]> list = q.getResultList();

This object list contains correct values for Hostname, AName and AId, but value of CName is incorrect, it is getting value of AName.
Also I tried to get value for another column of Table C, I got it.
What should I do to get values from columns of different table having same column names?

When above query run through query browser I am getting correct result that is all actual values.