What are joins..how many types of joins are there?

Answer Posted / niranjan.b

In sql joins are 3 types
1.Inner join
2.Outer join
a)left outer join
b)right outer join
c)full outer join
3.Cross join

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to use "while" statements in oracle?

733


How to drop a stored function?

672


Please explain joins in oracle?

547


how to make an oracle object

1854


What is background process in Oracle?

624






while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

3865


What is the difference between pre-select and pre-query?

621


What is a cursor in oracle?

644


nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

1741


master table and child table performances and comparisons in Oracle ?

1662


What is the difference between $oracle_base and $oracle_home?

583


How do I manually uninstall oracle client?

514


What happens to the data files if a tablespace is dropped?

574


What is columnar storage what is the advantage?

544


What are the most common interview questions on ETL Testing for experience?

589