How to find unmatched record in related tables

Assuming a table Dependent in which all records must contain a field Relation which contents must exist in any record of the table Master which field Target matches the Relation field:

SELECT Dependent.* from Dependent LEFT JOIN Master ON Dependent.Relation=Master.Target WHERE Master.Target IS NULL;