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.


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).





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
Define the terms i) Entity set ii) Relationship set Entity set: The set of all entities of the similar type is termed as an entity set. Relationship set: The set of all rela

What is storage manager?  A  storage  manager  is  a  program  module  that  gives  the  interface  between the Low level data  kept in a database and the application programs

You have a friend that runs a motor bike club that holds racing events at various venues on weekends, on a monthly basis. Some venues are private race tracks and some are dirt trac

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

Submit SQL INSERT Statements that will populate the database with sample data.  You must insert at least 5 records into each table in your database.Submit your SQL INSERT Statement

Gaps in sequence values can happen when: -     A rollback happens that is when a statement changes are not accepted. -     When the system crashes -     When a sequence i

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

Authorisation Authorisation is the culmination of the administrative policies of the organisation.  As the name shows, authorisation is a set of rules that can be used to verif

Why DML is used for? DML is used to Manipulation and processing of database. DML is provided for manipulation & processing of database. (Data stored in the database is processed

Define the concept of generalization A generalization is relationship between specific kind of thing and general thing. It is also known as "is-a-kind-of" relationship. Inher