Imagine you have a data set ‘a’ which contains data from another data set ‘b’. You want to retrieve the data that exists in ‘a’ but not in b. This can be accomplished using a left outer join filtering on where b is null:

LEFT OUTER JOIN b ON a.key=b.key WHERE b.key IS NULL