maxcompute left outer join on条件不支持不等值连接

oracle 里面的SQL如下：由于都是大表，mapjoin不合适，怎样改写成maxcompute 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;