simple join and inner join

Hi ,
I want to know clear difference between simple join and inner join with an example.Which one to be used on what situation?. Explanation with an example will help  a lot.Thanks
prashubkAsked:
Who is Participating?
 
johanntagleCommented:
JOIN and INNER JOIN are the same.
0
 
johanntagleCommented:
Quoting from http://arjudba.blogspot.com/2008/06/difference-between-join-inner.html :

"It is good to know the difference between join and INNER JOIN keywoed. Actually there is no difference. If we write JOIN then by default INNER JOIN is performed."
0
 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Strictly seen, a "simple join" can be anything: equi join, natural join, inner join, cross join (cartesian product), outer join. But convention is indeed that omitting the keyword "inner" will not make any difference, and any other join type has to be noted explicitly.
0
 
prashubkAuthor Commented:
All answers are correct.But this one gave me enough incite on the subject.thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.