在我看来，SQL显示两个文本及其价值观

Question

我希望向“护理人员付款”和“看护者无偿”展示，因为我认为护理人员离开了。

以下是我的代码

SELECT a.EmployeeUID AS [Employee ID]
       ,b.LongName AS [Leave type] (here i wanna show two leave type as one mentioned above)
       ,a.Mins AS [Leave balance
FROM   [dbo].[AbsenceBalance] a 
JOIN   [dbo].[AbsenceTypes] b ON     a.AbsenceTypesUID = b.UID
WHERE  b.UID IN (3,4,5,6,7)

。