34,593
社区成员
发帖
与我相关
我的任务
分享
Select Max(Id) As Id ,Title,(Select FieldC From TableC Where AId= Max(Id) ) From tableA A Inner Join TableB B On B.Id=A.BId Where B.FieldsA='xxx' Group By A.Title
SELECT T.Id,
T.Title,
C.FieldC
FROM (
SELECT MAX(Id) AS Id,
Title
FROM tableA A
INNER JOIN TableB B
ON B.Id = A.BId
WHERE B.FieldsA = 'xxx'
GROUP BY
A.Title
) AS T
INNER JOIN TableC AS C
ON C.AId = T.Id
SELECT a.id,a.Title,c.FieldC FROM (
Select Max(Id) As Id ,Title
From tableA A
Inner Join TableB B On B.Id=A.BId
Where B.FieldsA='xxx'
Group By A.Title
) a
INNER JOIN TableC AS c ON a.id=c.Aid
也不知道是不是这个意思啊