UsefulLinks
Computer Science
Databases
MySQL Database
1. Introduction to Databases and MySQL
2. Installation and Configuration
3. MySQL Architecture
4. SQL Fundamentals: Data Definition Language (DDL)
5. Data Types and Constraints
6. SQL Fundamentals: Data Manipulation Language (DML)
7. SQL Fundamentals: Data Query Language (DQL)
8. Joining Tables
9. Advanced SQL Queries
10. Indexing for Performance
11. Transactions and Concurrency
12. Stored Routines and Triggers
13. User Management and Security
14. Database Administration (DBA)
15. Advanced MySQL Topics
8.
Joining Tables
8.1.
Join Fundamentals
8.1.1.
Join Concepts
8.1.1.1.
Relationship-Based Queries
8.1.1.2.
Table Correlation
8.1.1.3.
Result Set Combination
8.1.2.
Join Syntax Variations
8.1.2.1.
ANSI SQL Syntax
8.1.2.2.
Comma-Separated Syntax
8.1.2.3.
Explicit vs. Implicit Joins
8.2.
Inner Joins
8.2.1.
INNER JOIN Syntax
8.2.1.1.
ON Clause Specification
8.2.1.2.
Join Condition Definition
8.2.2.
Equi-Joins
8.2.2.1.
Equality-Based Joins
8.2.2.2.
Primary-Foreign Key Joins
8.2.3.
Non-Equi Joins
8.2.3.1.
Range-Based Joins
8.2.3.2.
Inequality Conditions
8.2.4.
Multiple Table Joins
8.2.4.1.
Chain Joining
8.2.4.2.
Join Order Considerations
8.3.
Outer Joins
8.3.1.
LEFT JOIN (LEFT OUTER JOIN)
8.3.1.1.
Left Table Preservation
8.3.1.2.
Null Padding
8.3.1.3.
Use Case Scenarios
8.3.2.
RIGHT JOIN (RIGHT OUTER JOIN)
8.3.2.1.
Right Table Preservation
8.3.2.2.
Alternative to LEFT JOIN
8.3.2.3.
Readability Considerations
8.3.3.
FULL OUTER JOIN
8.3.3.1.
MySQL Limitations
8.3.3.2.
UNION-Based Emulation
8.3.3.3.
Complete Result Sets
8.4.
Specialized Joins
8.4.1.
CROSS JOIN
8.4.1.1.
Cartesian Product
8.4.1.2.
All Combination Generation
8.4.1.3.
Performance Implications
8.4.2.
Self-Joins
8.4.2.1.
Table Self-Reference
8.4.2.2.
Hierarchical Data Queries
8.4.2.3.
Alias Requirements
8.4.3.
Natural Joins
8.4.3.1.
Automatic Column Matching
8.4.3.2.
NATURAL JOIN Syntax
8.4.3.3.
Implicit Join Conditions
8.5.
Join Conditions
8.5.1.
ON Clause Usage
8.5.1.1.
Explicit Condition Specification
8.5.1.2.
Complex Join Conditions
8.5.1.3.
Multiple Condition Joins
8.5.2.
USING Clause
8.5.2.1.
Common Column Joins
8.5.2.2.
Simplified Syntax
8.5.2.3.
Column Name Matching
8.5.3.
Join Performance
8.5.3.1.
Index Usage in Joins
8.5.3.2.
Join Order Optimization
8.5.3.3.
Query Execution Plans
Previous
7. SQL Fundamentals: Data Query Language (DQL)
Go to top
Next
9. Advanced SQL Queries