I have a table that has been put together from several sources of data. Not all of the data in the original tables was complete. I need to go in and update the missing data. For example, I have the meter serial number in some records and not others. I need to populate the incomplete records with the data from the "good data".
I've created a view of the table to select the rows where METER_SERIAL is populated.
SELECT ACCOUNT_ID, METER_SIZE
WHERE (NOT (METER_SIZE IS NULL))
I want to update tblData with the METER_SIZE data where the ACCOUNT_ID fields are equal.