spring data jpa 原生sql union查询问题？

[加文哥]

大神：spring data jpa 好像不支持 union 有什么好的办法吗？
SELECT gc.id as id
c.content_path as contentPath,
c.thumbnails as thumbnails,
c.resources as resources,
c.is_enable as enableFlag
from gp_content gc,content c
where c.id = gc.content_id and gc.gp_id = g.id
union
SELECT uc.id as id,
c.content_path as contentPath,
c.thumbnails as thumbnails,
c.resources as resources,
c.is_enable as enableFlag
from users_content uc,content c
where c.id = uc.content_id

[lengyulone]

报什么错啊，原生SQL肯定可以查啊

[加文哥]

#1 原生的可以查我知道 但是多表返回的是 数组啊 怎么把他塞到实体类里呢？

[__san_niu_m]

引用 2 楼 baidu_25459327 的回复:

#1 原生的可以查我知道 但是多表返回的是 数组啊 怎么把他塞到实体类里呢？

用list泛型接收就行了啊