Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
Updating multiple columns in a single UPDATE statement
I wish to update the columns of a particular record in a table with values from another table. There would be 5 columns needing their values updated. I would prefer to do it in one statement because it has to run once through a procedure being called in a report button action trigger. Is it possible to do it in a single UPDATE statement? If yes then how?
Many thanx in advance for any attempt to help me with my above mentioned query.
0 · ·