8,497
社区成员
发帖
与我相关
我的任务
分享
var query = from a in A
join t in B.Take(1) on a.id equals t.aid
join c in C on t.cid equals c.id
select new { a, t, c };
貌似这样就可以了,谢谢大神!
--相当于如下SQL脚本
selct A.*,T.*,C.* from A a1 inner join (
select * from (
select ID,AID,CID,row_number() over(partition by ID order by DATE desc) rn
from B
) t where t.rn <=1) b1 on a1.ID=b1.AID
INNER JOIN C c1 ON b1.CID=c1.ID