need query to fetch non existing record

[AEISMX]

I need to write query.scenario: I have List filenames, which contains list of filename. I have to match these filename from database and fetch corresponding status and set it to map containing filename as a key and status as value.if filename doestnot present in database i have to set status as null.Thanks