i have a table of 2 columns

ex.

col1 col2
1 2
1 3
1 4
2 1
2 3
2 4
3 1
3 2

now i want to select all values of col2 that two different values of col1 have in common. for example the two values of col1 1 and 3 will give one value --> 2 because 1 and 3 in col1 have the value 2 in col2 in common.

How to do this ?

I wonder if you could explain your meaning more clearly,that would be very nice.I can sure that you can select the appropriate data from tables if you run the right select query language.

what are you using? phpmyadmin?

Assuming I have understood what you want, (which is very doubtful because it's pretty vague). You can't.

It will need a stored procedure.

i found a solution myself

SELECT t1.col2 FROM `mytable` as t1 inner join `mytable` as t2 on t1.col2 = t2.col2 where t1.col1 = val1 and t2.col2 = val2

now the result of this select needs to be joined with a second table where t1.col2 is linked with the primary key of the second table.

how do this ?

the query above should work for you ...

I think query suggested by Falcone really works.