NOT IN 查询不起作用，SQL Server 2008

之前查询的第一部分not in运行并给我一个包含 100 条记录的列表。第二个查询运行并给出 75 条记录的列表。我正在尝试编写的查询not in是获取一个结果集中的记录，而不是另一个结果集中的记录。我得到的错误是incorrect syntax near the word not.

SELECT distinct  Patient.patientid
FROM Patient INNER JOIN
 patientICD ON Patient.patientid = patientICD.patientid AND Patient.admissiondate = patientICD.admissiondate AND 
                      Patient.dischargedate = patientICD.dischargedate INNER JOIN
                      tblICD ON patientICD.primarycode = tblICD.ICD_ID
WHERE     (tblICD.descrip LIKE N'%diabetes%') and  not in
(
SELECT    distinct Patient.patientid
FROM         Patient INNER JOIN
 patientICD ON Patient.patientid = patientICD.patientid AND Patient.admissiondate = patientICD.admissiondate AND 
                      Patient.dischargedate = patientICD.dischargedate INNER JOIN
                      tblICD ON patientICD.primarycode = tblICD.ICD_ID
WHERE     (tblICD.icd_id LIKE N'25000')
) 

是否允许编写查询expression AND NOT IN (select query?

您需要指定第二个查询中不包含哪些字段

and Patient.patientid not in