An example of using intersection between two tables

David Kerber · *nix forums beginner Joined: 18 May 2005 Posts: 40

In article <1112677195.992132.135910@g14g2000cwa.googlegroups.com>,
zeldorblat@gmail.com says...

ZeldorBlat · *nix forums Guru Wannabe Joined: 01 Mar 2005 Posts: 272

Intersect simply returns the rows that are the same from two different
queries. For example, consider the following:

Table Store_Information
store_name Sales Date
Los Angeles $1500 Jan-05-1999
San Diego $250 Jan-07-1999
Los Angeles $300 Jan-08-1999
Boston $700 Jan-08-1999

Table Internet Sales
Date Sales
Jan-07-1999 $250
Jan-10-1999 $535
Jan-11-1999 $320
Jan-12-1999 $750

and we want to find out all the dates where there are both store sales
and internet sales. To do so, we use the following SQL statement:

SELECT Date FROM Store_Information
INTERSECT
SELECT Date FROM Internet_Sales

Result:

Date
Jan-07-1999

Let it be known to all that I ripped this off from:
http://www.1keydata.com/sql/sql-intersect.htm
(the very first result in a Google search for "sql intersect")

amos_s12@zahav.net.il · *nix forums beginner Joined: 27 Mar 2005 Posts: 3

Hello

Can somebody can write an example of using the intersection operation between
two tables.

The example will be very helpful to me in writing some of my store procedures

Thanks ahead
Amos

Google