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
Explain Hashing techniques The hashing techniques can be categorized as: Static Hashing Techniques - In this method, the data can be viewed a collection of buckets, along with

What is known as a search key? An attribute or set of attributes used to look up records in a file is known as a search key.


Define Aggregate functions and what aggregate functions supported by the MySQL To calculate a summary value from a set of individual values and uses one of the functions known

Explain outer join? Outer Join - If there are any values in one table which do not have corresponding value(s) in the other, in an equi-join which will not be chosen. Such ro

What is a dataset? A dataset is an in-memory database that is disconnected from any regular database, but has all the significant characteristics of a regular database. Dataset

Describe the term- State Diagram State Diagram: An object could receive a sequence of the input instructions. The state of the object can differ depending upon sequence of in

What is Data Storage? The storage structures and access methods used by database system are specified by a set of explanation in a special type of DDL called data storage-defin

what are the main characteristics of database

What are the different integrity constraints in RDBMS? The various integrity constraints in RDBMS are as: Primary Key: primary key is a grouping of one or more attributes