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.