SELECT LEFT JOIN but only the record that every matched value is null
If you want just rows which has NULL values, you can use this;

SELECT fname,location_id
FROM name WHERE fname NOT IN 
(SELECT fname FROM name WHERE location_id IS NOT NULL)


The last row in code eliminate rows which have a value different than NULL