Posts in: Self Joins and Aliases

Self Joins and Table Aliases in MySQL

Use self joins and aliases to compare rows within the same table, useful for hierarchical or peer comparisons.