试试
select c.merchant_order_id,d.merchanr_order_id from report.t_cashier_buried_info c,
report.t_acquire_order d
where c.merchant_order_id=d.merchant_order_id(+)

也可以做个10046 把结果传上来看看

你说的这种方法可以我试过
我做个10046看看

应该是c.merchant_order_id字段名写错了，select下看是否报错

应该是bug

最后问题原因找到了吗？
try
select dummy,d.merchanr_order_id
from dual b left join
report.t_acquire_order d
on dummy=d.merchant_order_id

以及

select dummy,d.merchanr_order_id
from dual b left join
report.t_cashier_buried_info d
on dummy=d.merchant_order_id

patch17551261