Prev Next

MySQL JOINs with Aliases and Derived Tables

Aliases and derived tables can be used to simplify complex join queries, making them more readable and efficient. Derived tables are subqueries that are treated as temporary tables.

Example: Using Aliases and Derived Tables

SELECT k.king_name, d.kingdom_name
FROM (SELECT * FROM tamil_kings WHERE reign_end > 1000) AS k
JOIN kingdoms AS d ON k.kingdom_id = d.kingdom_id;

Code Explanation: This query uses a derived table to filter kings whose reign ended after 1000 AD and then joins this derived table with kingdoms using aliases for readability.

Key Takeaways

  • Aliases make SQL queries shorter and easier to read.
  • Derived tables allow you to use subqueries as temporary tables in joins.
Prev Next