customers left table
| id | name | city |
|---|
orders right table
| id | customer_id | item | total |
|---|
Result
- Matched
- Kept with no match
- Dropped
| name | item | total |
|---|
Pick a join and see which rows match, which are kept and which are dropped. Change a customer_id to see the result update.
| id | name | city |
|---|
| id | customer_id | item | total |
|---|
| name | item | total |
|---|