Question

这条sql语句报错提示是：无法绑定由多个部分组成的标识符 "U.CreateDate"，各位大神帮忙看一下

Select * From (Select ROW_NUMBER() Over (Order By U.CreateDate Desc) As rowNum, * From (SELECT U.User_ID as [KEY],b.organization_code as 部门编号,U.User_Code as 用户编号,U.User_Name as 用户姓名,(case U.User_Sex when 1 then '男' when 0 then '女' else '未知' end) as 性别,U.CreateDate as 时间from Base_UserInfo U LEFT JOIN Base_StaffOrganize S ON U.User_ID = S.User_ID left join Base_Organization as b on S.organization_ID=b.organization_ID where U.DeleteMark !=0 AND U.xiaoquDdtCode='0203' GROUP BY U.User_ID,U.User_Code,U.CreateDate,U.User_Name,U.User_Sex,b.organization_code) As T ) As N Where rowNum > 0 And rowNum <= 15

Answer 1

Select * From (
  Select ROW_NUMBER() Over (Order By T.时间 Desc) As rowNum, * From (
    SELECT  U.User_ID as [KEY]
        ,b.organization_code as 部门编号
        ,U.User_Code as 用户编号
        ,U.User_Name as 用户姓名
        ,(case U.User_Sex when 1 then '男' when 0 then '女' else '未知' end) as 性别
        ,U.CreateDate as 时间
    from Base_UserInfo U 
    LEFT JOIN Base_StaffOrganize S ON U.User_ID = S.User_ID 
    left join Base_Organization as b on S.organization_ID=b.organization_ID 
    where U.DeleteMark !=0 AND U.xiaoquDdtCode='0203' 
    GROUP BY U.User_ID,U.User_Code,U.CreateDate
        ,U.User_Name,U.User_Sex,b.organization_code
  ) As T 
) As N Where rowNum > 0 And rowNum <= 15

把第一个U.CreateDate换成T.时间就可以了。

Answer 2

你这个是多表操作吧 去查一下C#中如何多表查询的代码 是什么就好了 记的了解结构