sql - 返回值不存在的所有数据

Question

我想知道工作是否没有“LI”CompCode。

SELECT 
    bSLHD.Job, SLCT.SL, APVM.Vendor, APVM.Name, SLCT.CompCode, SLCT.ExpDate 
FROM 
    bSLHD
INNER JOIN 
    SLCT ON bSLHD.SL = SLCT.SL
INNER JOIN 
    APVM ON bSLHD.Vendor = APVM.Vendor

标签： sqlsql-server

Answer 1

听起来你想要聚合。像这样的东西：

SELECT bSLHD.Job
FROM bSLHD INNER JOIN
     SLCT
     ON bSLHD.SL = SLCT.SL INNER JOIN
     APVM
     ON bSLHD.Vendor = APVM.Vendor
GROUP BY bSLHD.Job
HAVING SUM(CASE WHEN SLCT.CompCode = 'LI' THEN 1 ELSE 0 END) = 0;