Glossary term
What is inner join? Meaning for developers
Keeps only the rows that have a match in both tables.
Learn it properly · SQL & PostgreSQLLesson 1: Joins: Combining TablesPrimary and foreign keys, inner, left, right, full and cross joins with drawn result tables, self joins and the NULL trap in left joins.