ALTER TABLE tblestimates ADD billing_street_2 varchar(200) DEFAULT NULL AFTER billing_street;
ALTER TABLE tblinvoices  ADD billing_street_2 varchar(200) DEFAULT NULL AFTER billing_street;

UPDATE tblestimates as est
LEFT JOIN tblclients as cl ON cl.userid = clientid AND cl.tenant_id = est.tenant_id
SET est.billing_street = cl.billing_street,
    est.billing_street_2 = cl.billing_street2 ,
    est.billing_city = cl.billing_city , 
    est.billing_state = cl.billing_state,
    est.billing_state_id = cl.billing_state_id,
    est.billing_zip = cl.billing_zip,
    est.billing_country = cl.billing_country;
    
UPDATE tblinvoices as inv
LEFT JOIN tblclients as cl ON cl.userid = clientid AND cl.tenant_id = inv.tenant_id
SET inv.billing_street = cl.billing_street,
    inv.billing_street_2 = cl.billing_street2 ,
    inv.billing_city = cl.billing_city , 
    inv.billing_state = cl.billing_state,
    inv.billing_state_id = cl.billing_state_id,
    inv.billing_zip = cl.billing_zip,
    inv.billing_country = cl.billing_country;