INNER JOIN
Set Diagram
Table A (employees)
Table B (departments)
Matched
Sample Data
employees
| id | name | dept_id |
|---|---|---|
| 1 | Alice | 10 |
| 2 | Bob | 20 |
| 3 | Carol | 30 |
| 4 | Dave | null |
departments
| id | dept_name |
|---|---|
| 10 | Engineering |
| 20 | Marketing |
| 40 | Finance |