Sql not exists. Plus, it stops looking once it finds a row.

Sql not exists. LEFT JOIN / IS NULL: SQL Server.