Tagged articles
INNER JOIN
17 articles · Page 1 of 1
This article explains how placing filter conditions in ON versus WHERE clauses affects MySQL JOIN results, demonstrating with concrete examples that INNER JOIN behaves equivalently while LEFT JOIN preserves driving table rows only when conditions are in ON, with SQL code and result comparisons.
INNER JOINLEFT JOINMySQL
0 likes · 7 min read

This tutorial explains MySQL table joins—including inner, left, right, full outer, and exclusion joins—using Venn diagrams, sample tables, and SQL queries to illustrate each join type's result set.
FULL OUTER JOININNER JOINLEFT JOIN
0 likes · 12 min read

This tutorial demonstrates four methods for multi-table updates in MySQL—INNER JOIN, LEFT JOIN, subquery, and direct multi-table UPDATE—using order and product tables, showing how each handles non-matching rows differently with concrete SQL examples and result comparisons.
INNER JOINLEFT JOINMySQL
0 likes · 7 min read


liandkAug 19, 2026 · Databases
This article explains the four fundamental SQL JOIN types, shows when to use each in real business scenarios, and provides a step‑by‑step example that creates tables, inserts data, and demonstrates LEFT and INNER JOIN queries with practical tips for readability.
INNER JOINLEFT JOINMulti-table
0 likes · 3 min read

This tutorial explains SQL INNER, LEFT, and RIGHT JOINs through practical examples with a user-order-product schema, demonstrating each join type's behavior, result sets, and common pitfalls like Cartesian products and missing indexes.
INNER JOINLEFT JOINMySQL
0 likes · 15 min read

This tutorial walks through MySQL table joins—INNER, LEFT, RIGHT, and FULL OUTER—using clear diagrams, step‑by‑step SQL examples, and sample data, helping readers understand each join type, its result set, and how to emulate full outer joins in MySQL 5.7.
INNER JOINLEFT JOINMySQL
0 likes · 9 min read

This guide walks through MySQL's join operations—inner, left, right, and full outer—using a simple grocery‑items schema, showing how to create tables, write correct queries, avoid common pitfalls like unintended cross joins, apply aliases, and filter unassociated rows with WHERE and UNION.
FULL OUTER JOININNER JOINLEFT JOIN
0 likes · 13 min read

This article reproduces a slow‑query scenario caused by deep pagination with LIMIT, explains the underlying index mechanics, and presents several practical SQL techniques—subquery, INNER JOIN, and anchor‑record methods—to dramatically reduce execution time.
Back-tableINNER JOINIndex Optimization
0 likes · 11 min read

This article explains the different MySQL JOIN types—including INNER, LEFT, RIGHT, and simulated FULL OUTER joins—by creating sample order and customer tables, inserting test data, and showing the corresponding SQL statements and result sets with visual diagrams.
INNER JOINLEFT JOINMySQL
0 likes · 9 min read

This article analyzes a sluggish MySQL query, explains why the original plan performs a full table scan, and demonstrates how rewriting the EXISTS clause as an INNER JOIN and substituting the OR condition with a UNION dramatically reduces execution time from 42 seconds to 18 milliseconds.
INNER JOINMySQLPerformance Tuning
0 likes · 6 min read

Learn how MySQL’s powerful join operations transform simple table queries into meaningful results, covering Cartesian products, inner, left, right joins, aggregation with group functions, and practical filtering techniques, complete with sample data, SQL syntax, and execution examples.
INNER JOINLEFT JOINMySQL
0 likes · 14 min read

This article explains how MySQL may rewrite a LEFT JOIN as an INNER JOIN during optimization when the WHERE clause filters the joined table, demonstrates the behavior with sample class and student tables, and presents test cases confirming the optimizer's decision.
INNER JOINLEFT JOINMySQL
0 likes · 5 min read

This article explains the different SQL join types—including equi‑join, natural join, inner join, self‑join, outer joins, and cross join—detailing their syntax, behavior, and practical usage with example queries and optimization tips.
Cross JoinINNER JOINJoins
0 likes · 8 min read

The article explains seven SQL join techniques—including INNER, LEFT, RIGHT, FULL OUTER, and their exclusive variants—illustrated with diagrams and accompanied by complete SELECT statements that demonstrate how to combine rows from two tables based on matching keys.
INNER JOINLEFT JOINOuter Join
0 likes · 3 min read


ITPUBNov 1, 2016 · Databases
This tutorial demonstrates how MySQL inner, left, and right joins combine related tables, using student and score examples to show query syntax, result differences, and how missing data is handled with NULL values.
INNER JOINLEFT JOINMySQL
0 likes · 2 min read


21CTOOct 1, 2015 · Databases
An in‑depth guide shows how to illustrate various SQL join types—including inner, full outer, left outer, and cross joins—using Venn diagrams and concrete table examples, highlighting result sets, null handling, and the pitfalls of Cartesian products for large tables.
Cross JoinINNER JOINJoins
0 likes · 5 min read

This article explains the three types of SQL joins—inner, outer, and cross—detailing their variations such as equi‑join, non‑equi‑join, natural join, left/right/full outer joins, and provides clear example queries and result illustrations to help readers understand how to combine tables effectively.
Cross JoinINNER JOINJoins
0 likes · 5 min read
