Answered Questions
What is a join ? Explain the different types of joins ?
Asked By: Interview Candidate
| Asked On: Sep 7th, 2004
Join is a query which retrieves related columns or rows from multiple tables.Self join - joining the table with itself.Equi join - joining two tables by equating two common columns.Non-equi join - joining two tables by equating two common columns.Outer join - joining two tables in such a way...
User Panel
Categories
Interview Coaching
Interview Question
Career Counselling
Copyright © 2013 GeekInterview.com | All Rights Reserved
NH
NH
Inner joins returns all rows from both tables where there is a match whereas outer join is used in the situations where it is desired to select all rows from the table on the left.
In Full Outer Join we get both matched and unmatched data from both the tables
whereas Cartesian join is a join in which each row of one table is cross multiplied with each row of the second table