I want to know What's the difference between
INNER JOIN,LEFT JOIN,RIGHT JOIN,FULL JOIN
i'm confused in that
Reading this original article on The Code Project will help you a lot: Visual Representation of SQL Joins.
Also check this post: SQL SERVER â€“ Better Performance â€“ LEFT JOIN or NOT IN?.
Find original one at: Difference between JOIN and OUTER JOIN in MySQL.
The content is written by members of the stackoverflow.com community.
It is licensed under cc-wiki