直接上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
直接上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