Types of joins ?

Answer Posted / lakshminrayana reddy

5 types
1) Equi join
2) cartesian join
3) non-equi join
4)outer join(+)
i)left outer join
ii) 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

Does sql*plus also have a pl/sql engine?

563


What is acid property in a database?

586


What is the syntax and use of the coalesce function?

604


What program will open a mdb file?

503


How do I remove all records from a table?

570






What is a temp table?

571


What is query syntax?

523


How many sql commands are there?

675


What is the difference between jpql and sql?

555


how to install mysql? : Sql dba

580


How do you delete duplicates in sql query using rowid?

543


what are sequences

1098


how to load data files into tables with 'mysqlimport'? : Sql dba

528


How many developers work on postgresql?

568


What is range partitioning?

522