1) SELF JOIN 2) EQUI JOIN(OR) INNER JOIN 2.1) NON-EQUI JOIN 3)OUTER JO

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 ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the difference between numeric and autonumber?

980

how to create a new view in mysql? : Sql dba

924

Can we create table in function?

945

What is the use of sql trace?

936

What is faster join or subquery?

998

Why do we create views in sql?

1129

Explain dml and ddl?

962

How can we find duplicate records in a table?

926

What is %type in sql?

947

what is oracle database ? : Sql dba

1007

How can we implement rollback or commit statement in a trigger?

1016

what is the use of set statement in tsql? : Transact sql

993

Where the sql database files are stored?

1000

What is loop in pl sql?

1018

Can a key be both primary and foreign?

979