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
10A.53 Code an Oracle Database trigger to enforce the constraint that an employee can never change his or her department. 10A.54 Code an Oracle Database trigger to allow the

give some example real life situation where DBMS are most suitable

Define about the Stored Procedure - It's a set of T-SQL statements combined together to perform a single task formed by combining numerous small tasks. - When you essentiall

Gyan Gurukul is a software company that provides software related solution. Ashutosh Dubey who is the director of Gyan Gurukul want a three-level schema architecture for the Gyan G

What is Nested Queries explain in details? Nested Queries - A SELECT query could have subquery(s) in it. While a SELECT query having another SELECT query in it, is known as n

What is catalog in DBMS? Catalog - A relational DBMS maintains information about every table and index in which it contains. A catalog is a collection of special tables that st

Retrieve the S&S In-Chapter Database (in Microsoft Access format) from the text's Web site (or create the tables in Table 4-5 in a relational DBMS product). Write queries to answer

A relation instance indicates as r is a collection of tuples for a given relational schema at a exact point of time. A relation state r of the relation schema R (A 1 ,A 2 ,.....

Which is a legal expression in SQL? SELECT NAME FROM EMPLOYEE is a legal expression in SQL.

Project Description: Oracle Certified Professional with 20 years of practice, Oracle version 6.0.34, 7.3, 8.0, 8i, 9i, 10G, 11G, 12C. Crossplatform migration, Informix, MSSql