Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Selecting same pair only ones !
HI PH, thanks for your help, but this select statement that you suggest to try fetches only those pairs that are not pairs both ways a,b b,a. this i did know on addvance. I have tryed to use B.NEIGHBOUR=A.HOME AND B.HOME=A.NEIGHBOUR in select statement for my problem but OFFCOURCE it doesn't... -
Selecting same pair only ones !
HI, I have a db table where first two columns are HOME and NEIGHBOUR and simplistic data in these columns is HOME NEIGHBOUR a b a c a d b a b c b d c a c b c d d a d b...
