SELECT TOP(@PageSize) T.* FROM
(
SELECT
U.*, P.*, ROW_NUMBER() OVER (ORDER BY U.UserID) AS RowNo
FROM
UserTable U
LEFT JOIN ProfileTable P
ON U.UserID = P.UserID
)AS T
WHERE T.RowNo > @PageSize * (@PageIndex - 1)结果出错,错误信息为:
The column 'UserID' was specified multiple times for 'T'.因为在UserTable和ProfileTable表中,都有UserID这个字段存在。而且由于两个表的字段都很多,我不可能用AS一个一个字段地写出来。那该如何解决呢?谢谢!
(
SELECT
U.*, P.*, ROW_NUMBER() OVER (ORDER BY U.UserID) AS RowNo
FROM
UserTable U
LEFT JOIN ProfileTable P
ON U.UserID = P.UserID
)AS T
WHERE T.RowNo > @PageSize * (@PageIndex - 1)结果出错,错误信息为:
The column 'UserID' was specified multiple times for 'T'.因为在UserTable和ProfileTable表中,都有UserID这个字段存在。而且由于两个表的字段都很多,我不可能用AS一个一个字段地写出来。那该如何解决呢?谢谢!
联合是UNION字段名有重复,看来你只能这那样写出来了. 纯属个人看法仅供参考