maxcompute left outer join 不等值On 连接条件查询

原来在oracle 里面的SQL语句，
insert into tmp_t_mz_ry_jhdj_add

  select a.*
    from tmp_t_mz_ry_jhdj a
    left join t_jztp_gx_sum b on ((a.zgxr = b.zgxr and a.cgxr = b.cgxr) or
                                 (a.zgxr = b.cgxr and a.cgxr = b.zgxr))
                             and b.gxxl like '1104%'
    left join tmp_t_mz_ry_lhdj c on a.zgxr = c.zgxr
                                and a.cgxr = c.cgxr
                                and a.gxfssj < c.gxfssj
   where b.zgxr is null
     and c.zgxr is null;

在left join on条件中存在不等值查询，maxcompute left outer join不支持，但是表的数据量都非常大，用map join不合适，怎样修改SQL ，实现原来的效果