using left join causes incorrect results with materialization and derived tables

SELECT t.SID, t.NAME,t.ID_NO,t.MOBILE,r.credit_status,t.amount,r.cust_active_amount,t.END_TIME,t.FILE_NAME

FROM (select sid,name,id_no,recommend_id_no,mobile,amount,end_time,FILE_NAME from tc_white_list

WHERE  recommend_id_no='ybr' ) t

  LEFT   JOIN (SELECT credit_status,id_no,cust_active_amount

             from datacqsn.tc_credit_request WHERE sid in(SELECT max(sid)

                                                          from datacqsn.tc_credit_request where credit_status>'0' GROUP BY id_no)) r

    on t.ID_NO=r.id_no