MySQL Tutorial - JOIN - Combine Tables
🔗 JOIN - Tables Jodo
Real Life:
📦 Orders + Customers
📚 Books + Authors
🎓 Students + Classes
Types
| JOIN Type | Returns |
|---|---|
| INNER JOIN | Matching rows only |
| LEFT JOIN | All left + matching right |
| RIGHT JOIN | All right + matching left |
Example
SELECT orders.id, customers.name
FROM orders
JOIN customers ON orders.customer_id = customers.id;