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 purpose of %type and %rowtype data types with the example?

988

Explain the methods used to protect source code of pl/sql.

1015

Can you load data into multiple tables at once? : aql loader

1066

What do you mean by stored procedures?

1011

Can we use pl sql in sql server?

1081

How do I upgrade sql?

998

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

954

How run sql*plus commands that are stored in a local file?

1059

Is there a 64 bit version of ssms?

958

what is data manipulation language? : Sql dba

1012

What schema means?

887

What does a pl/sql package consist of?

972

What are packages in pl sql and also explain its advantages?

1033

how to start mysql server? : Sql dba

1195

What is embedded sql in db2?

1013