📖 SQL Joins - Part 1

📍Types of joins used very often includes -

✔️LEFT JOIN - All data from the left table but common data from the right table
✔️RIGHT JOIN - All data from right table and common data from the left table
✔️INNER JOIN - Only common data from both the tables
✔️OUTER JOIN - All the data from both the tables keeping null values with no common keys
✔️UNION - Stack table data on top of one another
✔️CROSS JOIN - All possible combinations of data from both the tables

📖 SQL Joins - Part 2