sql复杂查询：A表与B表一对多，查询A表所有用户对应B表中的数据，去除B表中的日期最大值

直接上sql：SELECT
l.*

FROM
Users u,
Location l
WHERE
u.id = l.Userid
AND l.[time] = (
SELECT
MAX ([Time])
FROM
Location
WHERE
UserId = l.Userid
)
AND l.Comid = 24