Outer join, Database Management System

Outer Join: The use of Outer Join is that it still joins those tuples that do not have matching values in common columns are also contained in the result table. Outer join places null values in columns where there is not a match among tables. A condition involving an outer join is that it cannot use the IN operator or cannot be related to another condition by the OR operator.

Example:

There is an example of left outer join (which only considers the non-matching tuples of table on the left side of the join expression).

SELECT CUSTOMER.CUTOID, CUSTONAME, ORDERID

 FROM CUSTOMER LEFT OUTER JOIN ORDER

WHERE CUSTOMER.CUSTOID =   ORDER.CUSTOID;

 

Output: The following result suppose a CUSTID in CUSTOMER table who have not issued any order so far.

CUSTOID                  CUSTONAME                        ORDERID

-------------------          ----------------------    ------------

10                           Pooja Enterprises                   1001

12                           Estern Enterprises                 1002

3                             Impressions                          1003

15                          South Enterprises                   NULL

 

The other types of outer join are the Right outer join or complete outer join.

Posted Date: 3/11/2013 2:37:35 AM | Location : United States







Related Discussions:- Outer join, Assignment Help, Ask Question on Outer join, Get Answer, Expert's Help, Outer join Discussions

Write discussion on Outer join
Your posts are moderated
Related Questions
What is the difference between a key and a superkey? Key - A key a single attribute or a combination of two or more attributes of an entity set which is used to identify one

What is difference between primary index and secondary index? Primary Index a) It is an ordered file whose records are of fixed length along with two fields. b) Only base

Objectives differentiate DDBMS and conventional DBMS; Describe Network topology for DDBMS; Describe the concepts of horizontal and vertical fragmentation; Descr

What are the different kinds of database end users? Discuss the major activities of each? End-Users - End-users are the people whose jobs need access to the database for que

What are the aggregate objects in the data dictionary? Views Match codes Lock objects.

What are the Requirements of algorithm designer Algorithm designer should: i) Select proper algorithm so as to minimize implementation cost ii) Find most appropriate d

Question: i) Explain the terms data warehousing and data mining. ii) Discuss the importance of the following security principles that a digital firm should amongst others, n

Explain what is RDBMS ? RDBMS - RDBMS is a database management system (DBMS) which stores data within the form of relations. Relational databases are powerful since they need f

) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a picto

In the ER diagram, one example of subclassing is depicted following the Services entity. The subclasses Item Based and Time Based are created. The entity Services gains the attribu