Oracle INNER JOIN 🕸️

Mentor's Note: In a relational database, data is split into pieces to stay organized. INNER JOIN is the handshake that puts those pieces back together. It only shows records that have a match in both tables. 💡

---

🌟 The Scenario: The Dinner Party 🍽️

• Table A (Guests): List of all invited friends.
• Table B (RSVPs): List of friends who said "Yes".
• INNER JOIN: The actual dinner table. Only people who were invited AND said yes are sitting there.

---

💻 1. The Basic Syntax

SELECT columns
FROM table1
INNER JOIN table2 ON table1.id = table2.id;

Example: Names and Departments

SELECT E.first_name, D.department_name
FROM employees E
INNER JOIN departments D ON E.department_id = D.department_id;

---

🎨 Visual Logic: The Intersection

---

🏗️ Architect's Note: Join Methods 🛡️

Oracle uses different internal methods to join tables depending on their size:

1. Nested Loops: Good for small tables or when using indexes.
2. Hash Join: Used for large tables (very efficient).
3. Sort Merge Join: Used when data is already sorted.

• Architect's Tip: Ensure you join on indexed columns (like Foreign Keys) so Oracle can use Nested Loops for lightning-fast results!

---

📈 Learning Path

• Next: LEFT JOIN →