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 - CodeProject
I'm a pretty visual person. Things seem to make more sense as a picture. I looked all over the Internet for a good graphical representation of SQL JOINs, but I couldn't find any to my liking. Some had good diagrams but lacked completeness (they didn't have all the possible JOINs), and some were just plain terrible. So, I decided to create my own and write an article about it.
www.codeproject.com
|
