SQL Question - Need to do some kind of batch update from one table to another based on onlly one condition.
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)
This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.