sql1

select
userid, phone, nick, gender, addr, starttime, endtime
from  ods_zipper_update
union all
select a.userid, a.phone, a.nick, a.gender, a.addr,
 a.starttime,
 if(b.userid is null,a.endtime,date_sub(b.starttime,1))as endtime
from dw_zipper a
    left  join ods_zipper_update b
     on a.userid = b.userid;