,'F'),
-> ('b2006','G'),
-> ('b2006','H'),
-> ('b2005','A'),
-> ('b2005','B'),
-> ('b2005','E');
Query OK, 15 rows affected (0.00 sec)
Records: 15 Dupli
> 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 in
On 12/01/2008 08:30 AM, 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
