Types of joins ?

Answer Posted / ganesh

hai
1.Equi Join
2.Non-Equi Join
3.Cartesian Join
4.outer Join(+)(Left Outer Join/Right Outer Join)
5.Self Join

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we group by two columns in sql?

608


What does truncate mean in sql?

631


What are pl/sql cursors?

642


What is the difference between the conventional and direct path loads? : aql loader

806


What is an inconsistent dependency?

673






What is a design view?

608


Define SQL and state the differences between SQL and other conventional programming Languages?

777


What is procedure explain with example?

622


Is sql a oracle?

612


How does sql*loader handles newline characters in a record? : aql loader

661


What is pl sql collection?

609


what is auto increment? : Sql dba

661


What are tables and fields in the database?

639


What is embedded sql with example?

645


Why we use pl sql?

613