jpa join 子查询到 vo

[老爸是程序员]

用的是 jpa 做CURI ，现在想实现下面的连表查询，试了很多方法，都没成功，看下有大神能帮忙解答不

select me.address as address, me.totalChecked as totalChecked, me.avatar as avatar, info.checked as checked, info.checkedTime as checkedTime, info.upvoteNumber as upvoteNumber, info.username as username
from (select member1.address, member1.totalChecked, member1.avatar, member1.username
from Member member1
where member1.status = 0) as me
left join (
select checkDayInfo.username, checkDayInfo.checked, checkDayInfo.checkedTime, checkDayInfo.upvoteNumber
from CheckDayInfo checkDayInfo
where checkDayInfo.date = '2020-04-17'
) as info
on me.username = info.username
order by info.checked desc, info.checkedTime asc

[liuliu16888888]

你这写的太乱了，眼花缭乱那种，提供个思路给你 IF OBJECT_ID('QUERY_DATAS') IS NOT NULL DROP TABLE QUERY_DATAS GO WITH QUERY_DATAS AS ( SELECT 1 A,2 B, 3 C ) SELECT 1 FROM QUERY_DATAS 用WITH CTE AS 就能解决你的问题，AS去掉，眼睛都看疼