Natural join-table handling, Database Management System

Natural Join: It is the similar like Equi join except one of the duplicate columns is removed in the result table. The natural join is the most usually used form of join operation.

Example :

SELECT CUSTOMER.CUTOID, CUSTONAME, ORDERID FROM CUSTOMER, ORDER

WHERE CUSTOMER.CUSTOID=ORDER.CUSTOID;

 Output will be:

custoid                            custoname                           orderid

-----------                        ---------------------        ----------

10                                   Pooja Enterprises                  1001

12                                   Estern Enterprises                 1002

3                                      Impressions                        1003

Posted Date: 3/11/2013 2:36:30 AM | Location : United States







Related Discussions:- Natural join-table handling, Assignment Help, Ask Question on Natural join-table handling, Get Answer, Expert's Help, Natural join-table handling Discussions

Write discussion on Natural join-table handling
Your posts are moderated
Related Questions
Assigning Responsibility for Operation Many operations might have obvious target objects, but some of these operations could be used at numerous places in an algorithm, by one

Explain the use of constraints in functional model with suitable example. A constraint shows relationship between two objects at same time, or   among various values of the sam

Differentiate between Key and superkey? Key and superkey - A key a single attribute or a combination of two or more attributes of an entity set in which is used to identify o

Define Deadlock prevention These protocols make sure that the system will never enter a deadlock state. There are two methods to deadlock prevention. One approach makes sure t

What do you mean by an execution plan? Why is it used? How will you view it? a.) An execution plan can be known as a road map which textually or graphically illustrates the dat

Describe sequential file organization.  Explain the rules for (i)  Inserting a new record. (ii)  Deleting an existing record.          Ans:A sequential f

What is the main advantage of the object model? What are its different components? The object model focuses on the logical data structures. Each object model comprises of many

Define Deadlock detection If a system does not employ a few protocols that make sure deadlock freedom, after that a detection and recovery scheme should be used. An algorithm

statical data

Ask questiwhat is row indicator in database on #Minimum 100 words accepted#