i have table
(id1,id2)
1.row [1,2]
2.row [2,1]
3.row [3,4]
4.row [4,3]
5.row [5,6]
6.row [6,5]
i want to get result:
1.row [1,2]
3.row [3,4]
5.row [5,6]
or
2.row [2,1]
4.row [4,3]
6.row [6,5]
i try anithing, (but not temporarry table), to eliminate cross data, but ... , can you help please, how i get my result?
Rado, thanx very much.