Equi join-table handling, Database Management System

Assignment Help:

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

 

 

 

 


Related Discussions:- Equi join-table handling

ER diagram, #question. acompani datdbase needs to store information about e...

#question. acompani datdbase needs to store information about employees (identified by a social security number,with salary and phone as attributes) and departments (identified by

What are the advantages of having an index structure, What are the advantag...

What are the advantages of having an index structure?      Ans: The index structures commonly provide secondary access paths, which offer alternative ways of accessing the reco

DBMS, You are managing the following database system: • DBMS: Oracle 11g...

You are managing the following database system: • DBMS: Oracle 11g • OS: Sun Solaris • System architecture: Web-based application using ASP.Net • Purpose of Server: HR manage

Write a program within embedded sql to associative relation, Write a progra...

Write a program within embedded SQL to associative the total trip expenses of the salesman named ‘John' for the relations. EXEC SQL BEGIN DECLARE SECTION; long total_expenses;

Define transitive dependencies, What do you understand by transitive depend...

What do you understand by transitive dependencies? Define with an example any two problems that can take place in the database if transitive dependencies are available in the datab

xml, basic structure of xm

basic structure of xml

Employee elation with information, Consider a database application that dea...

Consider a database application that deals with an Employee relation with information such as SIN, name, data of birth (DOB), and DID (the ID of the department at which the employe

aggregate functions-data manipulation language, Aggregate functions ...

Aggregate functions Some of these functions are min, count, max, and avg. These functions help in getting consolidated information from a set of tuples. Example:

The structured query language, The Structured Query Language INTRODUCT...

The Structured Query Language INTRODUCTION Database is an organised set of information about an entity having controlled redundancy and serves numerous applications. DBMS

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd