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

how to rename an existing column in a table? : Sql dba

514

What if we write return in procedure?

788

Is primary key an index?

537

Which tcp/ip port does sql server run?

538

Why is partition used in sql?

550

How long does it take to learn pl sql?

610

What is the use of sqldataadapter?

539

what is oltp (online transaction processing)? : Sql dba

536

What are the advantages of pl sql?

607

What is cursor in pl sql with examples?

481

What does sign mean sql?

573

Give the order of sql select?

614

What is fmtonly in sql?

534

How do you update a value in sql?

549

Is sql procedural language?

554