Hi
I need to update rows from one table to another while matching key values in rows in both tables.
The issue is that some columns in source table might be empty and I don't want these empty columns from source table to overwrite columns in destination table. How do I do that?
In theory I can update one row at a time if that would help. I just don't know beforehand what source columns would contain data in each row as it is being entered online by users.
Thanks
Regards