What is a join and explain different types of joins?

Answer Posted / kavita

Join are used to link then retrive data from same or
different database(both have atleast one common attribute).

Join are basically of two types:
1)Equi Join
2) Non equi join

Equi join are those in which we use "=" operator in
condition.They are further divided into
a)inner join:-In this only those rows are return which
satisfy the condition.

b)Outer join:In this all rows are return in which either one
table satisfy the condition
Outer Join are again classified into left join and right join.

2)Non Equi Join are those in which we use ">","<",">=","<="
operator for retriving tuples from two tables

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the process of the user request and data generating?

893


Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

1824


If a column is an image value type, how you can compare column values? How can you use this column in join clause?

808


To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

3759


Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

1840


Explain about a primary key?

787


What is the maximum length of an extended property?

761


What are data modelling techniques?

752


Write short notes on manual refreshes.

2520


What are the three basic rules which are to be followed for the relational model of the database?

794


How to use timestamp datatypes

1805


What are the three types of database design?

785


In which table collections errors are stored.

2169


You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

749


What is the physical representation for a many-to-many relationship?

847