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
Question: (a) List four disadvantages of the File Processing System as compared to the Database Systems. (b) The integrity of a database is enforced by integrity rules. One

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

Create Student DB and perform delete operation? STUDENT (name, student#, class, major) COURSE (course name, course#, credit hours, department) SECTION (section identifier, co

Consider the subsequent relation schemes:  Project (Project#, Project_name, chief_architect)  Employee (Emp#, Empname)  Assigned_To (Project#, Emp#)  Give expression i

courier company er-diagram

define anomalies and different types of anomalies with example

E-R Model This data model is based on real world that consists of basic objects named entities and of relationship among these objects. Entities are illustrated in a database

Question 1: (a) Explain the legal meaning of :- (i) Computer Service Person (ii) Data holding (b) Explain how the law ensures Data protection and Security. Qu

Define physical and logical data independence. How does this architecture help in achieving these? Data independence entails that change in one view must not need a change in t

System level permissions : With the use of data dictionary you can view them.       Let us take the table name as user_sys_privs (used in oracle).       DESCRIBE USER_SYS_PRI