<h1 id="cross-join"><a aria-hidden="true" class="anchor-heading icon-link" href="#cross-join"></a>Cross Join</h1>
<p>A Cartesian Product that matches every unique value from one table to every unique value on another table for the complete list of every unique pairing:</p>

















<table><thead><tr><th>Table</th><th>One</th></tr></thead><tbody><tr><td>1</td><td>A</td></tr><tr><td>2</td><td>B</td></tr></tbody></table>

















<table><thead><tr><th>Table</th><th>Two</th></tr></thead><tbody><tr><td>1</td><td>C</td></tr><tr><td>2</td><td>D</td></tr></tbody></table>

























<table><thead><tr><th>Result</th><th>Table</th></tr></thead><tbody><tr><td>1</td><td>AC</td></tr><tr><td>2</td><td>AD</td></tr><tr><td>3</td><td>BC</td></tr><tr><td>4</td><td>BD</td></tr></tbody></table>
<hr>
<strong>Backlinks</strong>
<ul>
<li><a href="/DevLog/notes/sj6quy3ratynvgdk5b11ncr">Joins (DevLog)</a></li>
</ul>

Cross Join


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


Table	One
1	A
2	B

Table	Two
1	C
2	D

Result	Table
1	AC
2	AD
3	BC
4	BD