Need a little sql help...

2011-01-24 Thread DURETTE, STEVEN J (ATTASIAIT)
Hi all, My SQL mojo seems to have left me. Here is the situation, I have 1 table. In this table there are some times two rows that should have actually been one. Here is an example to explain. Table: Name, Age, address one, address two Row 1: Steve,40,123 Anystreet,NULL Row 2:

Re: Need a little sql help...

2011-01-24 Thread Greg Morphis
How do you know the 2 Steve's are the same Steve? What if there was another Steve who was also 40 but lived elsewhere? Can you provide some more realistic data? And how you'd know they were the same Steve? or whomever? On Mon, Jan 24, 2011 at 12:57 PM, DURETTE, STEVEN J (ATTASIAIT)

RE: Need a little sql help...

2011-01-24 Thread DURETTE, STEVEN J (ATTASIAIT)
Subject: Re: Need a little sql help... How do you know the 2 Steve's are the same Steve? What if there was another Steve who was also 40 but lived elsewhere? Can you provide some more realistic data? And how you'd know they were the same Steve? or whomever

Re: Need a little sql help...

2011-01-24 Thread Dean Lawrence
Subject: Re: Need a little sql help... How do you know the 2 Steve's are the same Steve? What if there was another Steve who was also 40 but lived elsewhere? Can you provide some more realistic data? And how you'd know they were the same Steve? or whomever

Re: Need a little sql help...

2011-01-24 Thread Greg Morphis
. Sorry for the confusion, I just redact true data whenever possible. -Original Message- From: Greg Morphis [mailto:gmorp...@gmail.com] Sent: Monday, January 24, 2011 2:00 PM To: cf-talk Subject: Re: Need a little sql help... How do you know the 2 Steve's are the same Steve? What