SELF-GUIDED BA PRACTICE Packages available · Access after confirmed paymentSee packages ↗

Business analysis glossary

Inner Join

What it is

An inner join returns only the rows that have matching values in both tables, based on the join condition. Rows in either table without a match are left out. It is the default JOIN in SQL and is used when you only want records that exist on both sides.

Why it matters

Inner joins are correct for many questions, such as orders with their customer details, but they can silently drop data when matches are missing. Analysts should compare row counts before and after joins to make sure nothing important disappeared without anyone noticing.

Example

Joining orders to the courier shipment table with an inner join returns 9,400 rows, but there are 10,000 orders. The analyst investigates and finds 600 orders were never shipped. That finding becomes the main point of her report to the operations manager.

Used in these guides

CHECK BEFORE CONTINUING

Keep your work safe