Unanswered: help filtering rows which fields have the same value in another row
I am trying to figure out how to make my select statment
here is the table
What I would like to do is creat a select statment which will return only 1 row
if any other row if there is another row which col1 matches current rows col2
example the results would be returned like this
so the select statment filters out any of the other rows where the
col 1 was equal to the other rows col2 and the col2 was equal to that same other rows col 1.
I am sure the answer is simple I cant wrap my head around it.