What is outer join, Database Management System

What is Outer join?

 They can be employed while we want to keep all the tuples in R, or all those in S or all those in both relations in the result of the JOIN in spite of of whether or not they have matching tuples in the other relation.

Posted Date: 5/6/2013 3:28:19 AM | Location : United States







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

Write discussion on What is outer join
Your posts are moderated
Related Questions
Company XYZ is an advertising company. It has its own website but the search facilities offered are not reliable. The company is willing to invest to acquire new machines and sof

What are the two types of indices? The two types of indices are:- A)     Dense index B)      Sparse index

Deadlock And Its Prevention: As seen earlier, though two phase locking protocol handles the trouble of serialisability, but it causes some troubles also. For instance, consider th

What are the two main goals of parallelism? Load -balance multiple small accesses, so that the  throughput of such accesses enhances. Parallelize large accesses so that the res

explain at least five widly used case tools

Explain trivial dependency? Functional dependency of the form α ->β. is trivial if α C β. Trivial functional dependencies are satisfied by all the relations.

external and internal mapping with examples

What are the parts of SQL language? The SQL language has various parts: data - definitition language  Data manipulation language  View definition  Transaction contr

Problem: ‘Users and Information system specialists need to spend inordinate amounts of time locating and gathering data' (Watson and Hal, 1998) Recent developments in the ar

What are the two types of errors? The two types of errors are: a) Logical error b) System error