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

Does pl sql work in mysql?

919

What is index example?

950

How is data stored in sql?

1001

How many functions are there in sql?

961

What are the different datatypes available in PL/SQL?

1027

what is user defined functions? : Sql dba

975

Define a temp table?

965

What is foreign key in sql with example?

890

what is sql in mysql? : Sql dba

1120

what is the syntax for using sql_variant_property? : Transact sql

987

What is the purpose of cursors in pl/sql?

1078

What are system versioned tables?

965

What is the use of <> sql?

931

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

900

What are transaction and its controls?

967