1-Inner Join 2-Outer Join 3-Left Join 4-Right Join 5-Self Join

What are different types of joins ?

Question Posted / amar misra

Answer Posted / amar misra

1-Inner Join
2-Outer Join
3-Left Join
4-Right Join
5-Self Join

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is datawarehouse? : Sql dba

565

can a stored procedure call itself or recursive stored procedure? : Sql dba

577

Is sql a programming?

545

What is Difference Between Unique and Primary Key Constraints?

604

How does one load ebcdic data? : aql loader

643

What is the purpose of a sql?

524

what is a database? : Sql dba

604

What is number function in sql?

525

What is the mutating table and constraining table?

556

What is a rank in sql?

534

What is a dynamic query?

569

Can we use delete in merge statement?

512

What is $$ in sql?

549

Will truncate release space?

514

Can we join more than 2 tables in sql?

489