Inner join and outer join

Question

In which place to use inner join and outer join. need an example.

Argyle Ghost · Answer

I believe that Sql Inner Joins return rows when there is at least one match in both tables. The outer join (Sometimes can be referred to as just a "LEFT JOIN" or "RIGHT JOIN") can return rows even if there are no matches in the other table. Such as if you call a LEFT JOIN (a.k.a Left Outer Join) if there are no matches in the right table, it will still return rows from the left table. Hope this helps.

Sam Hobbs · Answer

Suthish, I understand. That happens to me a lot. It really happens often when this web site gives prizes, so then the people asking questions can be vague and other people will post many attempts to answer the question by guessing what the question is. In this situation, though, I think the question is clear enough, but it is also answered very easily by searching and simply looking at the list of artijcles in this web site.

Suthish Nair · Answer

Ha ha am asking him to explain, so that he can learn :)

Soft Corner · Answer

For Your Question , here is the article in this website :- http://www.c-sharpcorner.com/UploadFile/raj1979/SqlJoins10012008164642PM/SqlJoins.aspx Hope u got ur answer :)

Suthish Nair · Answer

Chandra, Can you explain "what is inner and outer joins, with an example"?

Inner join and outer join

Answers (5)