Having more than one join to the same table within a query can be confusing.
More than one join can create a messy SQL statement.
If you don’t use aliases they can be difficult to read.
If your database tables need to have many columns with the same relationship to another table. You can join them with aliases in a single efficient query.
Need a working example, with sample SQL statements? Check out my other post: How to join the same table twice in a single SQL query statement?
For more about MySQL please check out the MySQL terminology guide
Interested in more SQL tips? Please subscribe in the box below, for a weekly update of my newest posts every Tuesday!