I crawled the internet (read stackoverflow) many times to understand how actually each MySQL JOIN method works. There’s lot of brief and detailed explanations available if you google it, but this one i found seems descriptive and visual more than any other. Read the full article:
Visual Representation of SQL Joins
This article describes SQL Joins in a visual manner, and also the most efficient way to write the visualized Joins. |