AI engineering glossary · SQL databases
What is INNER JOIN?
INNER JOIN: A join that combines rows from two tables where the join condition is true and drops rows with no match on the other side. It is the default kind of join and answers questions needing data present in both tables.
INNER JOIN: an example
orders INNER JOIN customers ON orders.customer_id = customers.id returns only orders whose customer exists.
Related terms
More SQL databases terms
Where you learn it
INNER JOIN is part of the AI Engineering Program, which teaches it with notes, a hands-on lab and an exam. The first lesson is free.