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

What is the purpose of normalization?

537


How many types of index are there?

553


Which is better varchar or nvarchar?

550


what is myisam? : Sql dba

578


When should I use nosql database?

553






What is the basic structure of an sql?

575


what is isam? : Sql dba

576


How do we accept inputs from user during runtime?

548


Can 2 queries be executed simultaneously in a distributed database system?

649


What does joining a thread mean?

548


How many tables can a sql database have?

533


What is a join?

628


Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

622


how does a local variable is defined using t-sql? : Transact sql

546


What steps server process has to take to execute an update statement?

511