From: Peter Brawley
Date: December 1 2008 7:25pm
Subject: Re: Intersect question
List-Archive: http://lists.mysql.com/mysql/215420
Message-Id: <49343A18.2000102@earthlink.net>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="------------040409070909050402050907"

--------------040409070909050402050907
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

 > The task is to perform an intersection on 'name' column according to 
all distinct values in 'study' column.

Did you try ...

SELECT DISTINCT a.symbol
FROM test as a
JOIN test as b ON a.symbol=b.symbol
WHERE a.study <> b.study;

PB

-----

Andrej Kastrin wrote:
> I have the table 'test' which includes two columns: 'study' and 'symbol':
>
> study symbol
> a2008 A
> a2008 B
> a2008 C
> a2008 D
> b2005 A
> b2005 B
> b2005 E
>
>
> The task is to perform an intersection on 'name' column according to 
> all distinct values in 'study' column. During the experiments the 
> intersection was done 'manually' using the query:
>
> SELECT a.symbol FROM test as a, test as b WHERE a.symbol=b.symbol and 
> a.study="a2008" and b.study="b2005";
>
> So the result of the query above is (A, B).
>
> The question is how to implement this query more automatically, 
> without directly referencing to the study names, because I want to 
> implement it into a php script.
>
> Thank you in advance for any suggestions.
>
> Best, Andrej
>
> ------------------------------------------------------------------------
>
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg.com 
> Version: 8.0.176 / Virus Database: 270.9.11/1820 - Release Date: 11/29/2008 6:52 PM
>
>   

--------------040409070909050402050907--