Hi guys,
I've 2 tables, one which data must be update (Table 1) and second table with correct data (Table 2)
Table 1 looks like this:
| ID | COL2 |
| AAA | 1209200 |
| BBB | 2308197 |
| CCC | 1105194 |
| AAA | 1209200 |
| EEE | 0611201 |
Table 2
| ID | COL4 |
| AAA | 12092003 |
| BBB | 23081978 |
| CCC | 11051947 |
| EEE | 06112011 |
I need to update col2 in table 1 with values from col 4 from table 2
for each ID in table 1.
I try to use a subquery but it returns an error message (more then one row returned in subquery, which I understand)
Any clues? Or a procedure is necessary ?
Thank if you can help
Rgds
Carlos