[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Joins

Posted on 2011-10-04
3
Medium Priority
?
377 Views
Last Modified: 2012-05-12
Hi,
  What is difference between left inner join, right inner join and inner join?  If all are the same why phrase left inner join, right inner join is used?

Thanks a lot.  
0
Comment
Question by:amitabh04
3 Comments
 

Author Comment

by:amitabh04
ID: 36914106
Please respond as soon as possible.
0
 
LVL 32

Accepted Solution

by:
Ephraim Wangoya earned 2000 total points
ID: 36914136

There is nothing like 'left inner join' or 'right inner join'
You can only have left outer join and right outer join
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 36916462
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

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

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

831 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