Skip to content

Case

SQLJoinMethod.inner

An inner join.
case inner

Discussion

Most often, this type of join is what’s meant when saying simply, “a join”. An inner join is the result of filtering the Cartesian product (a cross join) of all rows in both tables with the join condition/predicate.