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
Who is Participating?
JOIN and INNER JOIN are the same.
Quoting from :

"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."
QlemoBatchelor and DeveloperCommented:
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.
prashubkAuthor Commented:
All answers are correct.But this one gave me enough incite on the subject.thanks
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.