Solved

inner join vs left join

Posted on 2010-11-17
3
286 Views
Last Modified: 2012-05-10
select * from af
left join am on am.orderid=af.amazonorderid




only want to see the results of the rows where am.orderid=af.amazonorderid

would this be inner join
0
Comment
Question by:rgb192
  • 2
3 Comments
 
LVL 60

Accepted Solution

by:
chapmandew earned 125 total points
ID: 34157697
yep.  inner join = records from both tables.
0
 
LVL 60

Assisted Solution

by:chapmandew
chapmandew earned 125 total points
ID: 34157704
0
 

Author Closing Comment

by:rgb192
ID: 34158917
thanks
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
count vs exists 9 49
Another way of doing this SQL 8 40
Incremental load example 2 43
ms sql + top 1 for each customer 3 38
If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This video discusses moving either the default database or any database to a new volume.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

759 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now