A join method that combines only the data matching on both sides.
A join method that returns only rows satisfying the join condition; data that exists on only one side isn't included in the result. When you write just JOIN without a qualifier, most RDBMSes default to interpreting it as an INNER JOIN, so whether to spell out INNER explicitly usually comes down to a readability preference.
© 2026 ITBGM