sql - 我的承认/重新接受 sql 查询没有选择所有重新接受

Question

我在存储过程中创建了一个临时表。下面的查询应该在 30 天内捕获重新接纳。但它并没有捕捉到所有的重新接纳。（有 3 个重新接纳，但它只捕获了 1 个）。

SELECT
       CH3.MedId,
       CH3.Name,
       CH3.Description,
       CH3.StartDate,
       CH3.EndDate,
       CH3.Length_of_Stay,
       CH3. Status,
       CASE
           WHEN CH3.MedId IN
                (
                    SELECT CH1.MedId
                    FROM currentmonth CH1
                        FULL JOIN previousMonth CH2
                            ON CH2.MedId = CH1.MedId
                    WHERE CH1.MedId <> 'NULL'
                          AND (DATEDIFF(DAY, CH2.StartDate, CH1.StartDate)) <= '30'
                ) THEN
               'Readmit'
           ELSE
               'Admit'
       END AS Admit_ReAdmit
FROM currentmonth CH3
ORDER BY CH3.Name;

标签： sql