If you have
Table1
id
name
and
Table2
id
name
Then you can do
SELECT Table1.* FROM Table1
LEFT JOIN Table2
ON Table1.ID = Table2.ID and Table1.Name = Table2.Name
WHERE Table2.ID is NULL
Essentially you're saying "Try to Join table 1 and Table 2 based on similar rows, and only return those rows from Table1 that don't exist in Table2"