MySQL Relationships (JOIN explained)
The visual diagrams still confuse me after so many years and I always forget…so here it is: INNER JOIN gets all records from one table that have some related entry in a second table LEFT JOIN gets all records from the LEFT linked table but if you have selected some columns from the RIGHT table, […]