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
Define Deadlock recovery measures                   To recover from deadlock, the cycle in the wait-for-graph should be broken. The common technique of doing this is to rollbac

What is MySQL? MySQL is a relational database management system which has eleven million installations. It can be used for both Linux and Window. Managing database includes add

Analyzing Association Traversal Association Traversal shall be understood properly for the association design explanation.  Analyzing association traversal means analyzing tra

Primary Index In primary index, there is a one-to-one relationship among the entries in the index table and the records in the major table. Primary index can be of two types:

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

What are called jukebox systems? Jukebox systems have a few drives and numerous disks that can be loaded into single of the drives automatically.

Dirty Reads: T10 reads a value which is updated by T9. This update has not been committed and T9 aborts. T9 T10 Value of x old value = 200


Question: In a multi-user database environment, locking mechanisms can be used to solve the three basic problems of concurrency. On the other hand, however, locking may also le

Differentiate between a Global and a Local temporary table? - A local temporary table exists only for the duration of a connection or if defined inside a compound statement, fo