What is meant by Join? What are the different types of
Joins available? Explain.

Answer Posted / mahesh

joins are used to relate two tables and display the result..

Types of join

1.inner join
2.outer join
2.1 left outer join
2.2 right outer join
2.3 full outre join
3.cross join

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which query operators in sql is used for pattern matching?

542


Define commit, rollback and savepoint?

573


Can we join two tables without common column?

512


Is sql considered coding?

567


What does the hierarchical profiler does?

566






What are the advantages of indexing?

519


Is sql similar to python?

536


what is 'mysqladmin' in mysql? : Sql dba

529


Is sql a case sensitive language?

514


How to run pl/sql statements in sql*plus?

591


What is package in pl sql with an examples?

545


What are the 3 types of behavioral triggers?

661


What do you mean by rowid?

538


how can we destroy the session, how can we unset the variable of a session? : Sql dba

545


What is break?

618