找到登录的代码了: Select a.ID,a.CreateDate,a.CreateUserID, a.RecordState,a.UserID,b.Name, a.LoginTime,a.LogoutTime,a.ComputerName,a.LoginIP from MSLogin as a left outer join MSUser as b on a.UserID=b.ID where (a.UserID<>-1) and (not b.name is null ) union Select a.ID,a.CreateDate,a.CreateUserID,a.RecordState, a.UserID,b.Name, a.LoginTime,a.LogoutTime,a.ComputerName,a.LoginIP from MSLogin as a left join MSRole as b on a.UserID=b.RoleID where ( b.RoleID=-1) and (not b.name is null )