SQL语句如下：
SELECT P.AppendNo AS LAB_APPLY_NO, PL.SquareName AS LAB_ITEM_CODE, PL.ComName AS LAB_ITEM_NAME, M.XJID AS MICRO_NO, O1.Remark AS MICRO_NAME,
MAX(M.KSSID) AS ANTI_NO, O2.Remark AS ANTI_NAME, M.MingGanDu AS SUSCEPT, M.MIC AS SUSQUAN, '' AS REF_RANGE, PL.ComName AS DESC_NAME,
M.KSSID AS RESULTNO, CASE WHEN p.PayType = '4' THEN '3' WHEN p.PayType = '5' THEN '0' WHEN p.PayType = '6' THEN '2' ELSE '0' END AS FILE_VISIT_TYPE
FROM dbo.Pat_patient AS P LEFT OUTER JOIN
dbo.XJ AS M ON M.PatientId = P.PatietntId LEFT OUTER JOIN
dbo.Pat_patientback AS PL ON PL.AppendNo = P.AppendNo LEFT OUTER JOIN
dbo.Organ AS O1 ON O1.Id = M.XJID LEFT OUTER JOIN
dbo.Organ AS O2 ON O2.Id = M.KSSID
WHERE (P.CheckDepId = '31') AND (P.AppendNo <> '')
在LAB_APPLY_NO这一列主键，同一个号码的情况下，我打圈标记的列，不能有重复的数据出现
大哥们，麻烦帮忙看看，小弟试过很多次了，都不行