1)Self Join 2)Equi join (or)Inner Join 2.1)Non-equi Join 3)Outer Join

what are the different types of joins?

Question Posted / a.jyothsna

Answer Posted / a.jyothsna

1)Self Join
2)Equi join (or)Inner Join
2.1)Non-equi Join
3)Outer Join
3.1) Left-Outer Join
3.2) Right-Outer Join
3.3) Full-Outer Join

Is This Answer Correct ?

14 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the difference between rename and alias?

966

Can a procedure in a package be overloaded?

984

What is the difference between microsoft access and sql?

961

Can we insert delete data in view?

899

When can we use the where clause and the having clause?

969

How do I find duplicates in the same column?

1000

what are the join types in tsql? : Transact sql

983

Explain isolation levels. : Transact sql

1017

Is there a way to automate sql execution from the command-line, batch job or shell script?

919

What is sql clause?

995

what is self join and what is the requirement of self join? : Sql dba

1078

How can I make sql query run faster?

963

What is difference between my sql and sql?

997

What is microsoft t sql?

882

What is the difference between delete and truncate commands?

978