Tagged articles
LEFT JOIN
30 articles · Page 1 of 1
This article explains the logical execution order of SQL clauses (FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY, LIMIT), why SELECT aliases aren't visible in WHERE, how HAVING differs from WHERE, JOIN/ON placement, LEFT JOIN pitfalls, and how to verify with EXPLAIN, distinguishing logical vs. physical execution order.
EXPLAINHAVINGLEFT JOIN
0 likes · 8 min read

This article explains the difference between SQL's written clause order and its logical execution order, detailing why WHERE cannot use column aliases, how HAVING filters groups, the impact of JOIN/ON placement in LEFT JOINs, and how to verify execution plans with EXPLAIN.
EXPLAINHAVING clauseLEFT JOIN
0 likes · 9 min read

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


ITPUBAug 7, 2026 · Databases
The article explains that in a LEFT JOIN the ON clause determines how rows are matched but never filters out rows from the left table, while a WHERE clause is applied after the join and can remove left‑table rows, illustrated with concrete SQL examples and step‑by‑step analysis.
LEFT JOINON clauseSQL
0 likes · 5 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

The article explains why adding conditions after a LEFT JOIN using AND does not filter the number of rows returned, clarifies the distinct roles of ON and WHERE clauses, and demonstrates the behavior with multiple SQL examples and visual illustrations.
LEFT JOINON clauseWHERE clause
0 likes · 5 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 explains why a LEFT JOIN always returns all rows from the left table, clarifies the difference between ON and WHERE clauses, demonstrates the behavior with multiple SQL examples and code snippets, and highlights the special handling of LEFT/RIGHT/FULL joins versus inner joins.
LEFT JOINON clauseSQL
0 likes · 6 min read

This article explains why adding conditions after a LEFT JOIN's ON clause does not filter rows, contrasts ON and WHERE behavior, and demonstrates the effect with multiple SQL examples and visual illustrations of temporary tables and join semantics.
Join TypesLEFT JOINON clause
0 likes · 6 min read

This article explains how LEFT JOIN works in SQL, clarifying the difference between ON‑clause conditions that affect the join process and WHERE‑clause filters that operate on the resulting temporary table, using multiple example queries and visual illustrations.
LEFT JOINON clauseSQL
0 likes · 5 min read

This article explains the difference between ON and WHERE clauses in MySQL LEFT JOIN, illustrates why a proposed optimization for DBLE sharding does not work, and provides practical examples and pseudo‑code to clarify how MySQL processes left joins.
DBLELEFT JOINMySQL
0 likes · 8 min read

This article explains why adding conditions after a LEFT JOIN's ON clause does not filter rows, contrasts ON and WHERE behavior, and demonstrates the differences with multiple SQL examples and visual illustrations of intermediate result tables.
LEFT JOINON clauseSQL
0 likes · 5 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 guide explains how LEFT JOIN creates a temporary result set, compares the effects of applying a WHERE filter after the join versus embedding the condition in the ON clause, and shows practical SQL examples with sample tables and result analysis.
LEFT JOINON clauseSQL
0 likes · 5 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 how LEFT JOIN always returns all rows from the left table, how conditions placed in the ON clause affect only the right‑table matching without filtering left‑table rows, and how a WHERE clause filters the final result, illustrated with multiple SQL examples.
LEFT JOINON clauseSQL
0 likes · 4 min read

This article explains how LEFT JOIN works in SQL, illustrates why duplicate rows can appear when joining tables, and provides practical techniques such as DISTINCT, GROUP BY, MAX, and IN subqueries to ensure a one‑to‑one result set while also covering RIGHT JOIN, INNER JOIN, update and delete operations, and the concept of Cartesian products.
LEFT JOINMySQLSQL
0 likes · 14 min read

The article explains why adding conditions after a LEFT JOIN using AND does not filter rows from the left table, contrasts ON and WHERE clauses, and demonstrates the behavior with SQL examples and step‑by‑step illustrations of intermediate result tables.
Join TypesLEFT JOINON clause
0 likes · 6 min read

This article explains how LEFT JOIN works in SQL, clarifying that the ON clause only matches rows without filtering left‑table records while the WHERE clause filters the joined result, and demonstrates the differences with multiple code examples and table illustrations.
LEFT JOINON clauseSQL
0 likes · 5 min read

This article explains why adding extra conditions after the ON clause in a LEFT JOIN does not reduce the number of rows from the left table, clarifies the difference between ON and WHERE filters, and demonstrates the behavior with practical SQL examples and diagrams.
LEFT JOINON clauseSQL
0 likes · 5 min read

This article analyzes a community‑raised issue where a left join between a global table and a sharded table produces incorrect results in Mycat but works as expected in DBLE, explaining the underlying execution‑plan differences and how DBLE correctly merges results to avoid duplicate data.
DBLEDistributed DatabaseGlobal Table
0 likes · 5 min read

This article examines why NOT EXISTS can perform poorly in MySQL, demonstrates how rewriting the query with a LEFT JOIN dramatically reduces execution time, and explains the underlying indexing and profiling details that affect query efficiency.
LEFT JOINMySQLNOT EXISTS
0 likes · 6 min read


ITPUBDec 17, 2019 · Databases
This article explains the fundamentals of LEFT JOIN in SQL, illustrates one‑to‑one, one‑to‑many, and many‑to‑many scenarios, compares ON versus WHERE conditions, and provides concrete MySQL and Hive examples with code snippets and visual diagrams to avoid common mistakes.
HiveJoin TypesLEFT JOIN
0 likes · 14 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
