34,594
社区成员
发帖
与我相关
我的任务
分享
SELECT id, [group], name, sex, age, num, tel, s_time, isflow, pubtime, userid, class_name, isstop,
(SELECT TOP (1) class_name
FROM dbo.release
WHERE (rosterid = dbo.roster.id)
ORDER BY f_time DESC) AS cn
FROM dbo.roster
SELECT id, [group], name, sex, age, num, tel, s_time, isflow, pubtime, userid, class_name, isstop,cn.class_name
FROM dbo.roster
cross apply
(SELECT TOP (1) class_name FROM dbo.release
WHERE rosterid = dbo.roster.id
ORDER BY f_time DESC) AS cn