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 to shutdown mysql server? : Sql dba

1107

what does it mean to have quoted_identifier on? : Sql dba

1147

What is oracle pl sql developer?

987

How does sql*loader handles newline characters in a record? : aql loader

1051

How to run sql commands in sql*plus?

1189

What is mutating sql table?

1117

How many sectors are in a partition?

1078

what is difference between delete and truncate commands? : Sql dba

1138

how to create a table index in mysql? : Sql dba

1067

What is the use of index in sql?

1020

How to assign sql query results to pl sql variables?

1086

What is join view in sql?

949

Why we use joins in sql?

987

what is a database lock ? : Sql dba

1176

Which version of sql do I have?

1063