select ot.*
from (select
t2.reject_reason,
t.user_name,
t.user_agentid,
t2.puch_type,
t2.puch_address,
long_to_date_str(t2.create_time) as puch_time
from T_OWS_RFC_SAFEGUARD t
left join t_ows_rfc_his t1
on t.opearate_no = t1.operation_no
left join t_ows_rfc_puch t2
on t.id = t2.rfc_safe_guardid)
pivot(max(puch_time), max(puch_address) p
for puch_type in(1 as puch,
2 as puch_1
)) ot