Sql Server – Get record where not exist on other table

I have two tables:

I want to get result in Campaign table – > 55,100.

Because they don’t exist in Job table.

>Solution :

You can use a not exists condition:

SELECT *
FROM   campaign c
WHERE  NOT EXISTS (SELECT *
                   FROM   jobs j
                   WHERE  j.campaignid = c.campaignid)