A safe template for “find missing related records.”
Section: Reusable patterns
Reusable anti-join template
sql
sql
SELECT a.*
FROM table_a a
WHERE NOT EXISTS (
SELECT 1
FROM table_b b
WHERE b.a_id = a.id
);Explanation
This template is highly reusable across auditing, cleanup, and onboarding workflows.
Learn the surrounding workflow
Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.
Related commands
Same sheet · prioritizing Reusable patterns
Reusable join template
A clean, readable structure for production queries.
WHERE on the right side can break a LEFT JOIN
Filtering after the join can remove rows you meant to preserve.
One-to-many joins can duplicate facts
Totals can be wrong when a base row joins to many detail rows.
Mismatched data types hurt join quality
Joining `INT` to `TEXT` or differently formatted keys can block index use and create hidden bugs.