I use SQL so little that I'm starting from scratch on it every time I have to use it...
My problem is that I have a few hundred rows in a column called A_ID in a table called FR like this:
Another table called A_BLY is like this:
A_BIL | A_ORIG
5782 | 1589
3842 | 1651
1249 | 1732
I need to replace the values in FR.A_ID with the matching values in A_BLY, so that table FR looks like this in the end:
I hope this is clear enough!
Any help would this would be greatly appreciated, thanks.