Left join missing rows
Rows with no match.
- Snippet
- SQL
- 3 blanks to fill
SELECT a.* FROM Table A a LEFT JOIN Table B b ON b.Key = a.Key WHERE b.Key IS NULL;
Orange words are blanks you have not filled yet. Press ⌘ Return to copy.
About this template
Rows with no match.
- Category
- Code snippets
- Pack
- SQL
- Type
- Snippet, a short message
- Asks for
- Table A, Table B, Key
Use it anywhere you write: email, chat, a document or a support tool. If you send it often, save the finished text as a snippet in ClipBuddy and paste it again from your clipboard history with ⌘⇧V.
Template source
The template as written, with its blanks in double braces, such as {{Name}}.
SELECT a.*
FROM {{Table A}} a
LEFT JOIN {{Table B}} b ON b.{{Key}} = a.{{Key}}
WHERE b.{{Key}} IS NULL;