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
prototype of a distributed information system for a national car part retail outlet chain.

Show, with the help of an example, that relatively high-level transitions result when system or program is stimulated by the outside events. In diagram below, we can observe i

Prepare a data flow diagram for computing the volume and surface area of a cylinder. Inputs are the height and radius of the cylinder. Outputs are the volume and surface area of th

Consider student (std_id, std_name, date_of_birth, phone, dept_name). Put the data for a student with student id200, name arun, birth date 1 February, 1985, phone number (01110 328

Describe multi key files

Object-based Models: Use objects as key data representation components . Examples:-   Entity-Relationship Model: It is a collection of real world objects known as entitie

What is a disjoint less constraint? Ans: It needs that an entity belongs to no much more than one level entity set.  Disjoint less constraint needs that an entity belongs to

What are uncommitted modifications? The immediate-modification technique permits database modifications to be output to the database whereas the transaction is still in the act

What are the Requirements of algorithm designer Algorithm designer should: i) Select proper algorithm so as to minimize implementation cost ii) Find most appropriate d

Designing the fields in the data base The following are the considerations one has to remain in mind while designing the fields in the data base. Coding, compression, en