Types of joins ?

Answer Posted / sam

)Inner Join
a)Equi join
b)Natural Join
c)Cross Join
2)Outer Join
a)Left join
b)Right join
c)Full join
3)Self Join

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why is partition used in sql?

541


What is sqlerrd?

521


What is the sql case statement?

568


What are secondary keys?

555


How to load data with sql*loader?

541






how to select first 5 records from a table? : Sql dba

505


What is a table?

563


What is snowflake sql?

573


What is nested table in pl sql?

547


Why plvtab is considered as the easiest way to access the pl/sql table?

611


what are the different type of sql's statements ? : Sql dba

514


How much ram can sql express use?

501


How do I remove sql plus from windows 10?

562


Is left join and outer join same?

536


What is trigger with example?

555