例えば、次の通り select hm.member_id, hm.member_sid, hm.jogai_flag, hh.regist_date as hgw_update_date, coalesce(hh.pv1,0)+coalesce(hh.pv2,0) as pv_size from xxxx_member hm join hgw_history hh on (hm.member_id=hh.member_id and hh.regist_dat…