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 top in tsql? : Transact sql

1113

How do I audit the sql sent to the server?

1004

What does subquery mean in sql?

1046

When are we going to use truncate and delete?

985

Is join an inner join?

963

What makes a good primary key?

1034

Is pl sql and postgresql same?

1123

How many sql databases can you have on one server?

1081

Can we use delete in merge statement?

1037

What is t sql used for?

1012

What is cursor and why it is required?

1180

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1204

How to avoid using cursors?

1119

What is the maximum number of columns in sql table?

1169

what is a trigger in mysql? Define different types of trigger. : Sql dba

1069