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
Consider the following relational scheme: R (a,b,c,d,e,f) and its corresponding set of FDs {d→ a, be → c, ac → e, b → f, f → d, a → c}. a. Is the following decomposition i) non

State the Object Design for Processing  The object design phase comes after analysis and system design phase. The object design phase includes implementation details like as i

#question.explain diversity and magnitude of organic compounds and general properties?

Differentiate sub-class and super-class? The specialization of a class is known as subclasses.eg: employee is a subclass of person and teller is a subclass of employee. Convers

How to design a formal and exact model How to design a formal and exact model of real-world problems by applying findings of analysis phase of OMT. The object design phase find

Consider the following relational schema: Doctor(DName,Reg_no) Patient(Pname, Disease) Assigned_To (Pname,Dname) Give expression in both Tuple calculus and Domain calculus for

lock and types of lock

How do you find the final model after iterative analysis? Why is iterative analysis of any of the problem needed? The final model serves as the base for system architectur

Why a report generator is used ? Report generator is used for print files on paper.

Consider the subsequent relation schemes:  Project (Project#, Project_name, chief_architect)  Employee (Emp#, Empname)  Assigned_To (Project#, Emp#)  Give expression i