Answer / kilari hemadri

Joins is used to relate two tables and display the result..
types of joins are

inner join
left join
right join
full join
cross join

inner join : It is used to display the common values in
both the tables based on the condition given.

left join : Left join displays all the contents of left
table and dislays the right table contents that are present
in left table.

right join : it is contraversy to left join

full join : it is combination of both left and right joins.

cross join: it takes one row of left table and matches with
all the rows in the right table.

Answer / jiya jain

The nature of relational database design shows that we will
have related data that is stored in different tables. To
retrieve data from two or more tables we use JOINS.

The JOIN clause tells the database how the data in the two
tables is related so that it can return a correct
representation of the related data.

There are different types of join.

Types of Join are :
1.Self Join
2.Inner Join
3.Outer Join
3.1. Right Outer Join
3.2. Left Outer Join
3.3 Full Outer Join
4.Cross join College Table

For more info go through

http://www.totaldotnet.com/Article/ShowArticle61_SqlServerJo
ins.aspx

Answer / mahesh

joins are used to relate two tables and display the result..

Types of join

1.inner join
2.outer join
2.1 left outer join
2.2 right outer join
2.3 full outre join
3.cross join

Answer / udaykumar

Join - joining of two tables to itself.
types of joins.....
simple/equi/inner
self
outer
cartesian.

Answer / dinesh kumar

Joins -- Getting related data from more than one table.

Type:
Inner JOin --Equi Join -- Non Equi join
Outer JOin --LEft Join -- Right Join -- Full Outer JOin
CRoss Join

what is the difference difference between procedure and packages

2 Answers   3i Infotech, Oracle,

Write a query to find five highest salaries from EMP table. (there is a column SALARY)

24 Answers   Cap Gemini, iNautix,

Can we use two order by clause in query?

0 Answers  

What are the types of dbms?

0 Answers  

How to write pl sql program in mysql command prompt?

0 Answers  

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

0 Answers  

Which one is better subquery or joins?

0 Answers  

If you want a column to be part of the result set, after which SQL keyword does it belong? 1. SELECT 2. FROM 3. WHERE 4. GROUP BY 5. HAVING

10 Answers   HCL, TCS,

What steps server process has to take to execute an update statement?

0 Answers  

Are dml statements autocommit?

0 Answers  

Can we have two clustered index on a table?

0 Answers  

What is database migration?

0 Answers