G
Guest
I've got a table I'm trying to update with data from another table.
The table to be updated has multiple columns but I'm concerned with two:
DEPT OLDACCTNUMBER
There may and probably will be duplicate values across these columns but not
for a specific dept/oldacctnumber combination.
100 5000
110 5000
200 6000
210 6500
300 5000
I'm trying to update it from a table with the following columns:
OLDACCTNUMBER DEPT NEWACCTNUMBER
There are no duplicates when you look at OLDACCTNUMBER and DEPT combined.
But there are certainly duplicates within OLDACCTNUMBER and NEWACCTNUMBER.
For example, here's sample data:
OLDACCT DEPT NEWACCT
5000 100 75000
5000 110 95000
5000 300 75000
I'm joining DEPT in both tables and OLDACCTNUMBER in both tables.
I'm getting the following message:
"Single-row update/delete affected more than one row of a linked table.
Unique index contains duplicate values."
I'm not sure what the issue is.
The table to be updated has multiple columns but I'm concerned with two:
DEPT OLDACCTNUMBER
There may and probably will be duplicate values across these columns but not
for a specific dept/oldacctnumber combination.
100 5000
110 5000
200 6000
210 6500
300 5000
I'm trying to update it from a table with the following columns:
OLDACCTNUMBER DEPT NEWACCTNUMBER
There are no duplicates when you look at OLDACCTNUMBER and DEPT combined.
But there are certainly duplicates within OLDACCTNUMBER and NEWACCTNUMBER.
For example, here's sample data:
OLDACCT DEPT NEWACCT
5000 100 75000
5000 110 95000
5000 300 75000
I'm joining DEPT in both tables and OLDACCTNUMBER in both tables.
I'm getting the following message:
"Single-row update/delete affected more than one row of a linked table.
Unique index contains duplicate values."
I'm not sure what the issue is.