What are different types of joins ?

Answer Posted / amit das

1.Equi join
2.Natural Join
3.cartegian/cross/non-equi join
4.outer join(+)>>a)left outer join
b)right outer join
5.self join

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

902


Why we use join in sql?

526


Does asenumerable execute the query?

594


what is normalization? : Sql dba

559


What is sql analyzer?

537






What is rowid in sql?

508


Are views faster than queries?

539


How many types of cursors are available in pl/sql?

584


How do I make sql search faster?

552


What is data abstraction in sql?

510


What is dml and ddl?

521


explain commit and rollback in mysql : sql dba

545


Can we use distinct and group by together?

586


How do you write an index?

524


What are the types of variable use in pl sql?

563