?
Solved

simple join and inner join

Posted on 2011-09-30
5
Medium Priority
?
349 Views
Last Modified: 2012-06-27
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
0
Comment
Question by:prashubk
  • 3
5 Comments
 
LVL 24

Expert Comment

by:johanntagle
ID: 36890426
JOIN and INNER JOIN are the same.
0
 
LVL 24

Expert Comment

by:johanntagle
ID: 36890429
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
 
LVL 24

Accepted Solution

by:
johanntagle earned 2000 total points
ID: 36890435
0
 
LVL 71

Expert Comment

by:Qlemo
ID: 36890460
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
 

Author Closing Comment

by:prashubk
ID: 36904165
All answers are correct.But this one gave me enough incite on the subject.thanks
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to recover a database from a user managed backup
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question