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 difference between stored procedure and trigger?

1058

What are character functions in sql?

891

Is left join and outer join same?

1001

explain mysql aggregate functions. : Sql dba

939

What is difference between stored function and application function?

1102

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2110

What is sql basics?

991

What is sqlerrm?

882

what is “go” in t-sql? : Transact sql

1039

What does varchar include?

905

What is normalization sql?

995

What is tuple in sql?

1005

Is mariadb a nosql database?

1005

Is and as keyword in pl sql?

904

Explain normalization and what are the advantages of it?

890