Thanks for the responses guys, here is more info.

Both tables already exist.

Table 1 has supplier information and about 24 columns & about 100K rows of data. One of those columns (its a serial number) is missing data (aka value is currently NULL) in various rows - maybe about 5-6K rows have null data.

The goal is to locate those rows in Table 1 where the value in the serial number column is NULL/empty and copy over those rows from Table 2. (Table 2 also has the same but latest supplier information and same 24 columns).

Hope that adds clarification. Please let me know if further info is needed. [/size]