GlobStudio

select to_char(a.start_ts,’yyyymmddhh24miss’), to_char(a.end_ts,’yyyymmddhh24miss’),
       case
         when a.field1_id = 0 then to_char(b.field1)
         when a.field1_id = -1 then ”
       end
       field1,
       case
         when a.server_id = 0 then to_char(b.server_id)
         when a.server_id = -1 then ”
       end
       server_id,
       to_char(a.field2) || ‘-’ || to_char(a.field3),
       a.point_type, to_char(a.points)
from pay3.PAY_POINT_EXCHANGE_CONFIG a,
       memb3.ps_game_config b
   where a.site_cd = b.site_cd
     and a.site_cd = ‘AT’
  group by a.start_ts,a.end_ts,
        case
         when a.field1_id = 0 then to_char(b.field1)
         when a.field1_id = -1 then ”
       end,
       case
         when a.server_id = 0 then to_char(b.server_id)
         when a.server_id = -1 then ”
       end,
       a.field2, a.field3,a.point_type, a.points