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

Ask an Expert

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

Write your message here..

Related Questions

Data envelopment analysis , I need a help with my assignment of data envelo... I need a help with my assignment of data envelopment analysis which is due for submission next week on monday the 10th Dec. Will you be able to help so that I can submit it on tim

Employee elation with information, Consider a database application that dea... Consider a database application that deals with an Employee relation with information such as SIN, name, data of birth (DOB), and DID (the ID of the department at which the employe

List any two disadvantages of a database system, List any two disadvantages... List any two disadvantages of a database system ? The disadvantages of database system are: • Database systems are difficult, complex, and time-consuming to design. • Substanti

Erd, er diagram on cosmetics. er diagram on cosmetics.

Need some database of usa and uk, I want Database Of United Kingdom with Cr... I want Database Of United Kingdom with Criteria of:\r\n\r\n1). Name, Number, City, State, Postal Code, Address, Email id, DOB.\r\n\r\n2). Unsecure Debts only adds Credit Card Payme

Discuss the mechanism to read data from and write to a disk, Discuss the me... Discuss the mechanism to read data from and write to a disk? Disk read/write heads are mechanisms in which read data from or write data to disk drives. The heads have gone by

Define the term multimedia database, Question : (a) Explain with the h... Question : (a) Explain with the help of appropriate examples the difference between ‘Data' and ‘Information'. (b) A digital image is an array of pixels, where each pixel h

Key constraint - relational constraints, This constraint shows that the key... This constraint shows that the key attribute value in each tuple must be unique, i.e., no two tuples have the similar value for the key attribute. This is because the value of the

Example of sequences, Example : Create a sequence named SEQSS that starts a... Example : Create a sequence named SEQSS that starts at 105, has a step of 1 and can take maximum value as 2000.  CREATE SEQUENCE SEQSS START WITH 105 INCREMENT BY 1 MAX VA

Define the term database, QUESTION (a)(i) Define the term database. ... QUESTION (a)(i) Define the term database. (ii) How is it different from a database management system? (b) What is the difference between an entity and an attribute? (c