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.