@lilsooin
Nothing here yet.
Nothing here yet.
Sep 4, 2025 · 2 min read · What 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...
Join discussionAug 23, 2025 · 2 min read · FULL 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...
Join discussionAug 21, 2025 · 3 min read · What 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...
Join discussionAug 14, 2025 · 4 min read · What 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...
Join discussionAug 8, 2025 · 1 min read · JOIN 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...
Join discussion