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
This project requires you to create a database design.  Your design will be documented in a set of Entity-Relationship diagrams.  Draw a set of Entity-Relationship diagrams to mode

The Proliferation of Object-Oriented Methods The first few years of the 1990s saw blossoming of around fifty various object oriented methods. This proliferation is a sign of g

Adding Redundant Associations for Efficient Access The expression redundant association means using "duplicate association for proficient access". While analysis, it is not a

Explain the Difference between DROP and DELETE DELETE deletes one or more than one tuples of a particular relation from the database. DROP is employed to remove a table from th

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 pictori

Explain cursors in SQL? Cursors in SQL - An object used to store the output of a query for row-through-row processing through the application programs. Cursors are constructs

10A.53 Code an Oracle Database trigger to enforce the constraint that an employee can never change his or her department. 10A.54 Code an Oracle Database trigger to allow the

Update or Modify operation alters the existing values. If these operations alter the value that is the foreign key also, the only check need is the similar as that of the Insert op

Give the limitations of SQL authorization. The code for checking authorization becomes intermixed with the rest of the application code. Implementing authorization by applic

List any two significant differences between a file processing system and a DBMS. File Processing System vs. DBMS Data Independence - Data independence is the capacity t