<h1 id="left-join-where-null"><a aria-hidden="true" class="anchor-heading icon-link" href="#left-join-where-null"></a>Left Join Where Null</h1>
<p>The same as <a href="/DevLog/notes/ahs5n2rskoyw7pwbti5gm3v">T-SQL Left Join</a> except the left side has records removed from is where are are <code>NULL</code>'s in the right side.</p>
<p>So this is saying when joining Women to Men on <code>MARRIAGE_ID</code> Where <code>MARRIAGE_ID IS NULL</code> means you will only see Married Men Returned. No Single Men and no Women at all.</p>
<hr>
<strong>Backlinks</strong>
<ul>
<li><a href="/DevLog/notes/sj6quy3ratynvgdk5b11ncr">Joins (DevLog)</a></li>
</ul>

Left Join Where Null


The hyperfixated rabbit hole diving knowledge base that is my brain looking at technology.
