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

Why are sql stored procedures used?

798

List the various privileges that a user can grant to another user?

772

how to get a list of columns in an existing table? : Sql dba

709

What is the difference between having and a where in sql?

799

What is the difference between mdf and ndf files?

778

Is full outer join same as cross join?

691

what are all the common sql function? : Sql dba

779

Is sql a case sensitive language?

706

What is exception? What are the types of exceptions?

789

Which language is used in sql?

727

What is assignment operator in pl sql?

764

what is 'mysqld'? : Sql dba

705

How many row comparison operators are used while working with a subquery?

753

What are hotfixes and patches?

689

What is error ora-01000: maximum open cursors exceeded

783