Skip to main content

cross join (anti)

Short Description

For every row in the left table a cross join will return every row in the right table.

Detailed Description

Unless there is a matching condition applied, for every row in the left table, a cross Join will return every matching row in the right table.

Anti Joins are used to return rows from the left table (left anti join) that are not present in the right, or to return rows from the right table (right anti join) that are not present in the left.

Search online

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.