I am trying to combine 2+ records into 1, in the same table with the same id_# but different data in different columns.
Does anyone know how to write a query to do that?
Any help is greatly appreciated.
What do you mean by combine? I mean, are they numeric values that you want to sum? Strings you want to concatenate? Videos you want to merge?
i mean, i am trying to take te values in one record and put them in another record.
example:
id age ssn
01 022 ----
01 ----- 333-55-2298
given the above, i am trying to have record 1 and 2 combined to
store 1 record.
Eh... in your case that's not really possible because you have no unique key from what I can see (the id is 01 in both rows). You'll have to do this by using some sort of script, but what if you have something like:
01, NULL, 'Foo'
01, 'Bar', NULL
01, 'Do', NULL
It's seems to me like you have some seriously screwed data :)
thats just it though, i have no over-lapping data.
the whole table is formatted like this.