What is a join?Explain the different types of joins?

Answer Posted / pratap

Joins are the methods used to access related data from one
or more tables. there are five types of join
1. Equi join(i.e. Inner join)
2. self join
3. left join
4. right join
5. outer join

Is This Answer Correct ?    17 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I truncate a sql log file?

528


What is difference between left and right outer join?

517


What does plv msg allows you to do?

673


Explain how exception handling is done in advance pl/sql?

548


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

615






How do I add a primary key to a table?

537


what is myisam? : Sql dba

573


Why schema is used in sql?

512


Can triggers stop a dml statement from executing on a table?

614


What is trigger price?

538


What is clustered index in sql?

582


What is thread join () in threading?

536


What is delimiter in pl sql?

582


What is aggregate function in sql?

529


What is the difference between sql and isql*plus?

509