spring data jpa 原生sql union查询问题?
加文哥 2017-12-20 06:42:06 大神: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