Equi join-table handling, Database Management System

Equi Join: A join in which the joining condition is based on equality among values in the common columns. Common columns show (redundantly) in the result table. Let us Consider the following relations:

  • Customer (custid, custname, ...........) and
  • Order (custid, ordered,....................)

Example: What are the names of all customers who have placed orders?

The needed information is available in two tables, customer and order. The SQL solution needs joining the two tables by using equi join.

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

FROM CUSTOMER, ORDER

WHERE CUSTOMER.CUSTOID=ORDER.CUSTOID;

The output might be:

Customer.custoid

order.custoid

custoname

orderid

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

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

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

----------

10

10

Pooja Enterprises

1001

12

12

Estern Enterprises

1002

3

3

Impressions

1003

 

 

 

 

Posted Date: 3/11/2013 2:35:41 AM | Location : United States







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

Write discussion on Equi join-table handling
Your posts are moderated
Related Questions
Question: (a) Why is it important to know the architecture rather than to start requirement capture when designing a large scale system? (b) Who are the different people in

a set of possible data value of an attribute is called??

What are the Issues when Selecting a Database Issues when Selecting a Database Storage space requirement: A database requires about triple storage space of the actua

I am going to develop a web site to present decision tree structure. For this, I want a web application with AJAX technology to connect the database and prepare the decision tree's

Suppose that in an organisation, an employee may do different roles in dissimilar projects. Say, RAM is doing coding in one project and doing designing in another. Suppose that the


Draw an ER diagram that shows the organization of a simple student database. The database captures the information about letter grades obtained by university students who enrolled

Describe a technique for direct search? Explain how data is stored within a file so which direct searching can be performed. For a file of unordered fixed length records by u

What is a homogeneous distributed database? In homogeneous distributed databases, all sites have the same database management system software, are aware of one another, and agr

What is a Phantom Deadlock? In distributed deadlock detection, the delay in propagating local information might cause the deadlock detection algorithms to recognize deadlocks