Understanding JOINs in MySQL and Other Relational Databases

SQL JOINs are often misunderstood and one of the biggest causes of database optimization problems. This brief tutorial explains JOINs and their use in MySQL and other relational databases. ... RIGHT JOINs are rarely used since you can express the same res

www.sitepoint.com