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) <sd1...@att.com> wrote: > > 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: Steve,40,NULL,456 Anystreet > > > > What should have been passed to me would have been: > > Steve,40,123 Anystreet,456 Anystreet > > > > The actual tables have a lot more columns and there are a few that this > can happen with. The columns are either (null and not null values) or > match exactly across rows. > > > > Any ideas what the SQL would look like to return a single row for each > with all of the fields merged? > > > > Thanks, > > Steve > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341147 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
