SQL Question - Need to do some kind of batch update from one table to another based on onlly one condition.
Posted on 2007-10-10
I have just created and released a new sale view in my database. I have already moved all my data into the new table, but one of my users decided it was a good idea to use an old field for data that wasn't suposed to go there. Needless to say I now need to move just the data in the one old field for her into the ne wtable. Luckily all the IDs are the same so this should just be a matter of getting the statement down with the right join info.
I'm guessing I would need "something" like below though I don't know too much about joing with updates:
UPDATE NEWSALE A1 SET A1.DESIGNNAME = A2.DESIGNNOTES WHERE A1.ACCOUNTMANAGER='Sales Persons ID' INNER JOIN OLDSALE A2 ON (A1.SALEID=A2.SALEID)