mud2
10-06-2008, 03:02 PM
No, not a simple DISCRETE problem:
I have two tables, TableA And tableB
TableA has a list of names, and the number of times each name has been added to the table. TableB has another list of names...some also on TableA, some not. I want to add those names from B to A that are NOT on A, but increase the number if times a duplicate would have been added.
TableA
Owen 5
George 2
Henry 1
TableB
Owen
Smitty
Harry
TableA After process
Owen 6
George 2
Henry 1
Smitty 1
Harry 1
And sometimes I might want to REMOVE some names from TableA, and not All...ie. Owen might go from 6 to 5.
Randy???
I have two tables, TableA And tableB
TableA has a list of names, and the number of times each name has been added to the table. TableB has another list of names...some also on TableA, some not. I want to add those names from B to A that are NOT on A, but increase the number if times a duplicate would have been added.
TableA
Owen 5
George 2
Henry 1
TableB
Owen
Smitty
Harry
TableA After process
Owen 6
George 2
Henry 1
Smitty 1
Harry 1
And sometimes I might want to REMOVE some names from TableA, and not All...ie. Owen might go from 6 to 5.
Randy???