I have the table 'test' which includes two columns: 'study' and 'symbol':
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.