used to retrieve desired data from more than 1 table we use join. joins

What is a join?Explain the different types of joins?

Question Posted / lakshminarayana reddy

Answer Posted / lakshminarayana reddy

used to retrieve desired data from more than 1 table we use
join.
joins types:- 1.Equi join
2.non-Equi join
3.outer join
4.Self join

Is This Answer Correct ?

10 Yes

7 No

Please Help Members By Posting Answers For Below Questions

How do I filter in sql profiler?

990

What are character functions in sql?

930

What is foreign key and example?

926

What is sql dialect?

1106

How do I start sql from command line?

1012

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1121

Explain the the update statement in sql?

1024

How can you load microsoft excel data into oracle? : aql loader

1165

How do you write a subquery?

1018

how to shut down the server with 'mysqladmin'? : Sql dba

999

define sql insert statement ? : Sql dba

1017

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1034

Can cursors be part of a trigger body?

1633

Where is pl sql used?

948

How to make a copy values from one column to another in sql?

1028