JPA native query, group function, different entity

[Bruno Frascino]

Hello all,

I have got an exciting problem.
I have got the following native query:

  
String sql = "select max(nvl(a_date, b_dt)) as max_a"
         + ", min(nvl(a_date, b_dt)) as min_a"
         + ", max(c_dt_tm) as max_c"
         + ", min(c_dt_tm) as min_c"
    + " from date_table "
    + " where number "
         + " between '" + startNumber + "' "
         + " and '" + endNumber + "' "
         + " and c_dt_tm is not null";

As you see, this will return 4 different dates for me, and they need to populate another entity instead of date_table, which i got the values from.
So, this is the question:

"How can I select values from a table A to populate actually not the entity related to table A but an entity B related to table B?"

I am trying to use native query and resultSetMapping, but I keep getting an error, invalid column name from Hibernate. I don't know how could I do it not using nativequery.

I'd appreciate any help, thanks!