spring jpa query with union all
@Query(value = "SELECT id, name FROM table1 " +
"UNION ALL " +
"SELECT id, name FROM table2", nativeQuery = true)
List<Object[]> findUnionAllResults();
@Query(value = "SELECT id, name FROM table1 " +
"UNION ALL " +
"SELECT id, name FROM table2", nativeQuery = true)
List<Object[]> findUnionAllResults();