I have 2 tables, the master table and a ‘temp’ table. The idea is that users can log in and make changes to some data in the master table but the changes are not saved to the mater but rather a new record is created in the temp table with the values of the record being edited. Mind you the user have just changed 1=one field so in the newly created record, the values in the master and temp tables will be the same except for one.
So for the admin to validate the changes made I need to show him which field(s) changed. The solutions I have seen found in my search like this one here compares just a couple of fields using subqueries.
My question is, as I have several fields to compare, do I go this route and create subqueires that compares each field or is there a more elegant way to do this?

My question is, as I have several fields to compare, do I go this route and create subqueires that compares each field or is there a more elegant way to do this?