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

Answer Posted / neet verma

A JOIN is a means for combining fields from two tables by
using values common to each.
there are three types of joins:-
1)inner join
a)eqi join
b)natural join
c)cross join
2)outer join
a)Left outer join
b)Right outer joins
c)Full outer join
3) self join

Is This Answer Correct ?    13 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

2862


What is a snapshot log?

546


What is an oracle cursor variable?

582


Is oracle a language?

499


What are the uses of synonyms?

581






Explain compound trigger in oracle?

521


Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1547


How to use subqueries with the exists operator in oracle?

584


How to connect to a remote server?

529


What privilege is needed for a user to create tables in oracle?

535


What is a package ? What are the advantages of package ?

574


What is the usage of merge statement?

647


What is oracle in java?

502


How to manage transaction isolation level?

530


Explain the use of ignore option in imp command.

544