8,494
社区成员
发帖
与我相关
我的任务
分享sql语句转linq
select B.Parent, B.Id, A.NAME, B.NAME,B.CreateUserName,B.CreateTime,
count(C.Name) AS Num
FROM CostSubject A
LEFT JOIN CostSubject B ON B.Parent=A.Id
LEFT JOIN CostSubject C ON C.Parent=B.Id
GROUP BY B.Parent, B.Id, A.NAME, B.NAME,B.CreateUserName,B.CreateTime
count(C.Name) AS Num
FROM CostSubject A
LEFT JOIN CostSubject B ON B.Parent=A.Id
LEFT JOIN CostSubject C ON C.Parent=B.Id
GROUP BY B.Parent, B.Id, A.NAME, B.NAME,B.CreateUserName,B.CreateTime
...全文
请发表友善的回复…
发表回复
Denuin多啦咧梦 2020-12-14
- 打赏
- 举报
A、B、C都是同一张表？
