By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,619 Members | 1,534 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,619 IT Pros & Developers. It's quick & easy.

difference between (left, right, inner, outer) join?

P: 21
difference between (left, right, inner, outer) join?

anybody can help me?

Thanx
Jul 12 '07 #1
Share this Question
Share on Google+
2 Replies


code green
Expert 100+
P: 1,726
When joining two tables
Expand|Select|Wrap|Line Numbers
  1. table1 JOIN table2 
This is MySql shorthand for INNER JOIN.
If no recordset is returned from table1 then the whole query returns nothing.
But if you specify RIGHT JOIN then table2 will still return its asked for recordset.
And vice versa for LEFT JOIN.
At least that the way it seems to work for me.
Jul 12 '07 #2

P: 2
difference between (left, right, inner, outer) join?

anybody can help me?

Thanx
I do not remember where I saw it first on the web, but here is a reproduction of the BEST explanation I know that explains the different types of JOINS. Here it is. Hope this helps you.

Sep 11 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.