August 5, 2008 at 3:35 am
Change the last line to:
AND i.ADDRESS_SEQ < i2.ADDRESS_SEQ
Explanation: If you have two addresses A and B, then as teh two are not the same you will get back both A,B and B,A. If you force an ordering A<B, then you get only A,B
Regards,
Andras
August 5, 2008 at 3:43 am
WOW ! happy days... it worked, thankyou very much !:D
So I presume that is always the case with that kind of data ? Oh your a life saver, id tried everything I knew to get this sorted, thank you.
August 5, 2008 at 4:34 am
With that surname you have to be the same Chris that worked with me for a short time at Sema in Liverpool - am I right?
If yes, how goes it? Last I heard you had moved to Brussels - still there?
Chris Quinn
August 5, 2008 at 4:54 am
Blimey ! 🙂
It is indeed my friend, how the devil are you ?!?! No im no longer in Brussels, been around a bit since then too but now back in UK, where are you these days, still in Sema ?
August 5, 2008 at 5:04 am
I've not been with Sema for over six years - I took redundancy in 2002 😀 and went to the Criminal Records Bureau for about 10 weeks, then went to the Blue Planet Aquarium as IT Manager for two years before they made me redundant. 🙁
I've been working as an Access/SQL developer for a firm in Chester for the last three years
Sema were taken over a couple of years ago and are now part of Atos Origin - there's still a small team working out of Old Hall Street, and Wilmslow is still up and running - I bump into people from time to time, and actually now work with a guy who worked at OHS
April 7, 2010 at 3:59 am
Hi Chris
Hope its you .............. wondered where you have got to??? Have you left Atos Origin?
Liz
(you know who I am!!!!!!!!!!)
April 7, 2010 at 7:59 am
Which Chris?
April 7, 2010 at 8:26 am
Chris Quinn of course ??????????????????????????????????????????
It must be you - your dry sense of humour .........
😉
Viewing 8 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply