SLSuin Leeinlilsooin.hashnode.dev·Sep 4, 2025 · 2 min readSQL JOIN for Beginners Part 6: EXCLUSIVE JOINWhat is an Exclusive Join? An Exclusive Join is used when you want to get the rows that appear in one table but not in the other. Put simply, you ignore the rows that match in both tables and keep only what’s left over from one side. If you picture a...00
SLSuin Leeinlilsooin.hashnode.dev·Aug 23, 2025 · 2 min readSQL JOIN for Beginners Part5: FULL OUTER JOINFULL OUTER JOIN FULL OUTER JOIN is a join that combines and returns all data from both the left and right tables. LEFT JOIN returns all rows from the left table along with matching rows from the right table. RIGHT JOIN returns all rows from the rig...00
SLSuin Leeinlilsooin.hashnode.dev·Aug 21, 2025 · 3 min readSQL JOIN for Beginners Part 4: INNER JOINWhat is INNER JOIN? INNER JOIN is a type of SQL join that retrieves only the common data (intersection) between two tables. In other words, it returns only the rows that exist in both tables, and it does not include any NULL values. Let’s take anothe...00
SLSuin Leeinlilsooin.hashnode.dev·Aug 14, 2025 · 4 min readSQL JOIN for Beginners Part 3: LEFT OUTER JOINWhat is a LEFT OUTER JOIN (LEFT JOIN)? In SQL, the JOIN clause is used to combine data from two or more tables into a single result set.Among them, LEFT OUTER JOIN (often shortened to LEFT JOIN) is one of the most commonly used types of JOINs in real...00
SLSuin Leeinlilsooin.hashnode.dev·Aug 8, 2025 · 1 min readSQL JOIN for Beginners Part 2: Types of JoinsJOIN in SQL is used to combine rows from two or more tables based on a related column.The main types of JOIN are as follows: Using Venn Diagrams can make understanding much easier. You can explore examples with diagrams and SQL statements on SQL Join...00