I want to know What's the difference between INNER JOIN,LEFT JOIN,RIGHT JOIN,FULL JOIN in Mysql

i'm confused in that


tizag.com/mysqlTutorial/mysqljoins.php tizag.com/mysqlTutorial/mysqlleftjoin.php

Written by Brad

google search "differece between different types of joins", you will get the answers

Written by Ashwini Dhekane


Written by James C

The manual explains it.

FULL outer JOIN doesn't exist on MySQL

Written by aleroot

I note that none the answers are specific to MySQL, which does have its own semantics in some areas. I would also like to see a decent write-up.

Accepted Answer

Reading this original article on The Code Project will help you a lot: Visual Representation of SQL Joins.

alt text

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.

Written by Pranay Rana
This page was build to provide you fast access to the question and the direct accepted answer.
The content is written by members of the stackoverflow.com community.
It is licensed under cc-wiki