SSRS显示基本信息

Question

如果员工请假，数据将显示

在这里输入图像描述

期望输出

但是，如果另一名员工没有休假，基本信息应该显示在给定的字段中。

在这里输入图像描述

无论他是否休假，我都要填写基本信息字段。

这是查询

  select LeaveRequest.LeaveRequestID,LeaveRequest.EmployeeID,userName,departmentName,designationName,RequestDate
  ,IsApproved,ApprovedDate,StartDate,EndDate,Name,PartOFDay 
  fromLeaveRequest
  inner join LeaveType
  on LeaveRequest.TypeID=LeaveType.TypeID

  inner join LeaveRequestDetails
  on LeaveRequest.LeaveRequestID=LeaveRequestDetails.LEaveRequestID

  inner join EmployeeInformation
  on LeaveRequest.EmployeeID=EmployeeInformation.employeeID

  inner join Departments
  on Departments.departmentID=EmployeeInformation.departmentID

  inner join Designations
  on Designations.designationID=EmployeeInformation.designationID

  where EmployeeInformation.employeeID=@empID**

Answer 1

问题在于EmployeeInformation上的内部联接，因为它正在筛选出不在LeaveRequest表中的任何员工in。尝试将其改为右联接：

right join EmployeeInformation
  on LeaveRequest.EmployeeID=EmployeeInformation.employeeID

Answer 2

将您的内连接替换为左外部连接。

谢谢你，SK