467,140 Members | 1,381 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,140 developers. It's quick & easy.

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

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

anybody can help me?

Thanx
Jul 12 '07 #1
  • viewed: 8103
Share:
2 Replies
code green
Expert 1GB
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
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.

Similar topics

1 post views Thread by Justin Hennessy | last post: by
2 posts views Thread by tricard@gmail.com | last post: by
4 posts views Thread by polycom | last post: by
9 posts views Thread by shapper | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.