Post #2737

🔥Now, let’s move to the most important SQL topic — JOINS 💯🔥 🧠 1. What is a JOIN? JOIN is used to combine data from multiple tables 👉 If data is stored in different tables → JOIN helps you connect them 📊 Example Tables 👨‍💼 employees emp_id name dept_id 1 Amit 101 2 Neha 102 3 Ravi 101 🏢 departments dept_id dept_name 101 IT 102 HR 🔗 2. INNER JOIN (Most Used 🔥) 👉 Returns only matching records SELECT e.name, d.dept_name FROM employees e INNER JOIN departments d ON e.dept_id = d.dept_id; ✔ Only employees with valid department ⬅️ 3. LEFT JOIN 👉 Returns all records from left table + matched from right SELECT e.name, d.dept_name FROM employees e LEFT JOIN departments d ON e.dept_id = d.dept_id; ✔ Even if department is missing → employee will still show ➡️ 4. RIGHT JOIN 👉 Returns all records from right table + matched from left SELECT e.name, d.dept_name FROM employees e RIGHT JOIN departments d ON e.dept_id = d.dept_id; 🔄 5. FULL JOIN 👉 Returns all records from both tables SELECT e.name, d.dept_name FROM employees e FULL JOIN departments d ON e.dept_id = d.dept_id; (Note: Not supported in MySQL directly — use UNION instead) ⚡ 6. Quick Summary • INNER -> Only matching rows • LEFT -> All left + matched right • RIGHT -> All right + matched left • FULL -> Everything 🎯 7. Practice Tasks 1. Get employee name with department name 2. Show all employees even if no department 3. Show all departments even if no employees 4. Find employees without department 5. Count employees per department (using JOIN) 🔥Practice Task Solutions👇 ✅1. Get employee name with department name (INNER JOIN) SELECT e.name, d.dept_name FROM employees e INNER JOIN departments d ON e.dept_id = d.dept_id; ✅2. Show all employees even if no department (LEFT JOIN) SELECT e.name, d.dept_name FROM employees e LEFT JOIN departments d ON e.dept_id = d.dept_id; ✅3. Show all departments even if no employees (RIGHT JOIN) SELECT e.name, d.dept_name FROM employees e RIGHT JOIN departments d ON e.dept_id = d.dept_id; 👉 (Alternative using LEFT JOIN — interview friendly) SELECT e.name, d.dept_name FROM departments d LEFT JOIN employees e ON e.dept_id = d.dept_id; ✅4. Find employees without department SELECT e.name FROM employees e LEFT JOIN departments d ON e.dept_id = d.dept_id WHERE d.dept_id IS NULL; ✅5. Count employees per department (using JOIN) SELECT d.dept_name, COUNT(e.emp_id) AS total_emp FROM departments d LEFT JOIN employees e ON d.dept_id = e.dept_id GROUP BY d.dept_name; ⚡ Mini Challenge 🔥 👉 Find departments with no employees ⚡Mini Challenge Solution👇 SELECT d.dept_name FROM departments d LEFT JOIN employees e ON d.dept_id = e.dept_id WHERE e.emp_id IS NULL; Double Tap ❤️ For More