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
(a) Data warehouse can be defined as "a subject-oriented, integrated, time-variant, non-volatile collection of data" in support of management's decision making process. Explain ea


Determine the Disadvantages of file based systems Some of the disadvantages of file based systems are like this: Data redundancy and inconsistency: the dissimilar applic

Explain the Attribute inheritance Ans: Throughout the rendering of the objects in a view, attribute sets of objects higher in the view hierarchy are inherited via objects below

why are older data models are being replaced by new data models

Explain five duties of Database Administrator? 1. DBA administers the three stages of the database and, in consultation along with the whole user community, sets up an defin

Draw an ER diagram for company''s database schema

What is a data dictionary?  A data dictionary is a data structure which keeps Meta data about the structure of the database i.e.  the schema of the database.

Explain what is Aggregation ? Aggregation: This is used whenever we intend to show a relationship between an entity and the relationship. There is no provision for this in th

Command Line Interfaces: These are interactive interfaces, character-based that let you use the complete power and functionality of the DBMS query language directly. They permit yo