用的是 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
uj5u.com熱心網友回復：
你這寫的太亂了，眼花繚亂那種，提供個思路給你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去掉，眼睛都看疼
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/9805.html
標籤：應用實例
上一篇：求助，SQL 2014中列屬性書字符型，里面的內容是數字，怎么使用，可以進行平均值計算，數字對比，等數值型可以做到的