I am trying to figure out how to make my select statment

here is the table
Table
--------
col1 col2

1 2
2 1
3 4
4 3
1 4
4 1



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

col1 col2
1 2
3 4
1 4

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.

Adam

Your brilliant!

thank you, thank you, i'll be here all week