GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Placement Papers  >  Manhattan Associates  >  SQL
Go To First  |  Previous Question  |  
 SQL  |  Question 4 of 4    Print  
What is the difference between Inner joins and Outer joins?

  
Total Answers and Comments: 1 Last Update: August 14, 2006     Asked by: swetha 
  
 Sponsored Links

 
 Best Rated Answer
—

No best answer available. Please pick the good answer available or submit your answer.
August 14, 2006 14:50:20   #1  
Ben Orlowitz        
RE: What is the difference between Inner joins and Out...
Inner joins return rows from both joined tables where the join keys are equal. Outer joins return all rows from the outer table (which can be on the right or left side of the join) and only those rows from the other join table where the keys are equal.
 
Is this answer useful? Yes | No

 Related Questions

Latest Answer : in "union" only distinct values will be selected but in "union all "values will be selected irrespective of its frequency. ...
Latest Answer : one can't rollback the operations which has commited. ...
Latest Answer : Inner joins return rows from both joined tables where the join keys are equal. Outer joins return all rows from the "outer" table (which can be on the right or left side of the join) and only those rows from the other join table where the keys are equal. ...
Read Answers (1) | Asked by : swetha

 Sponsored Links

 
Related Articles

What is difference between call by value and call by reference in function?

The arguments passed to function can be of two types 1. Values passed 2. Address passed The first type refers to call by value and the second type refers to call by reference. For instance consider program1 main() { int x=50, y=70; interchange(x,y); printf(“x=%d y=%d”,x,
 

Difference between Scholarship and Grant

Difference between Scholarship and Grant While both scholarships and grants allow students to pay for their tuition without having to pay the money back there are a number of key differences between the two Knowing the difference between grants and scholarship will make it much easier for students t
 

The Difference Between Data Mart and Data Warehouse

The Difference Between Data Mart and Data Warehouse The biggest decision facing most IT managers today is whether or not they should construct the data mart before the data warehouse Many vendors will tell you that data warehouses are hard to build as well as expensive mosgoogle If you listen to som
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape