Obtener los Registros que no esten dentro de en otra tabla

" SELECT inscriptions.* FROM inscriptions
LEFT OUTER JOIN inspections
ON inspections.inscription_id = inscriptions.id
WHERE inspections.inscription_id IS NULL
AND inscriptions.created_at ... "