How to merge two columns with incomplete information?
You can merge them in a SELECT, no problem. Something like:

SELECT CASE WHEN t1.zip1 in (NULL, 0) then t2.zip2 ELSE t1.zip1 END merged_zip
FROM table1 t1
  INNER JOIN table2 t2 on t1.customersid = t2.customersfid