COALESCE()[
^] is what you want to use. It will return the first non-null value.
For example:
SELECT COALESCE(a.State, c.State) AS State, COALESCE(a.line1, c.line1) AS line1, etc...
FROM Address1 a
LEFT JOIN CommonAddress c ON ... whatever your join is