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

What is left join in postgresql?

1002

What is the difference between between and in condition operators?

953

What are different types of sql?

1115

What is trigger in pl sql?

962

List the different type of joins?

1012

What is the limitation on the block size of pl/sql?

948

What is a file delimiter?

1026

How do I view tables in mysql?

925

How can we make an if statement within a select statement?

964

What are aggregate and scalar functions?

982

What are the different types of constraints?

1090

What is pivot table in sql?

1031

Is it possible to include an insert statement on the same table to which the trigger is assigned?

968

What are sql data types?

965

What is number function in sql?

921