Interested to Buy Any Domain ? << Click Here >> for more details...
What is a join and explain different types of joins?
- 2 Answers
- 5640 Views
- I also Faced
- E-Mail Answers
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
Explain about relational operator join?
What is DB Development software?
What is dbms and its application?
Who are end users in dbms?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
How to generate OIDS
In which table collections errors are stored.
What is an application role and explain a scenario when you would use one?
explain detail about ftp in datastage?
What is the physical representation for a many-to-many relationship?
Explain about xml databases?
What are the constraints on severity level in raiseerror?
Who are naive users?
What are the three types of database design?
Which data type cannot be used as a parameter in a udf?
