Get all records without fulfilling a condition

Transact-SQL
2

I wanted to post only SQL, but can't, have to make it look like a "sentence" because of this site's damn parser:

SELECT VARS.ID_JOB, VARS.ID_TABLE, VARS.NAMEJOB
FROM (
    SELECT ID_JOB, ID_TABLE
    FROM [VARIABLE]
    GROUP BY ID_JOB, ID_TABLE
    HAVING MAX(CASE WHEN NAME = 'SIZE' THEN 1 ELSE 0 END) = 0
) AS VARS
INNER JOIN DEF ON DEF.ID_JOB = VARS.ID_JOB AND DEF.ID_TABLE = VARS.ID_TABLE
1 Like