user--关健字加上[]--用not in少一次嵌套 SELECT TOP 2 [User].id, UserProfiles.User_serId FROM [User] a INNER JOIN UserProfiles b ON a.id = b.User_serId WHERE a.id not in (SELECT TOP 2 [User].id FROM [User], UserProfiles WHERE [User].id = [UserProfiles].User_serId ORDER BY [User].id ASC)
ORDER BY a.id
SELECT TOP 2 a.id, b.User_serId FROM [User] a INNER JOIN UserProfiles b ON a.id = b.User_serId WHERE a.id not in (SELECT TOP 2 [User].id FROM [User], UserProfiles WHERE [User].id = [UserProfiles].User_serId ORDER BY [User].id ASC)
SELECT
TOP 2
[User].id,
UserProfiles.User_serId
FROM
[User] a
INNER JOIN
UserProfiles b ON a.id = b.User_serId
WHERE a.id not in
(SELECT TOP 2 [User].id FROM [User], UserProfiles
WHERE [User].id = [UserProfiles].User_serId
ORDER BY [User].id ASC)
ORDER BY a.id
TOP 2
a.id,
b.User_serId
FROM
[User] a
INNER JOIN
UserProfiles b ON a.id = b.User_serId
WHERE a.id not in
(SELECT
TOP 2
[User].id
FROM
[User], UserProfiles
WHERE [User].id = [UserProfiles].User_serId
ORDER BY [User].id ASC)
ORDER BY a.id