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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.