query result showing diff
Hi
Both queries are left outer join query.... but results are different.... please suggest me.. what reason is it?
version: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
:PL/SQL Release 12.1.0.2.0 - Production
Query-1
select m.*, sm.suname from POWDER_COAT_MAST m left OUTER JOIN Supplier sm ON sm.sucode = m.sucode and m.company_id = sm.company_idand m.Serial_No like '%' || :refNo ||'%'and m.Issue_RefNo like '%' || :IssueRefNo ||'%'and m.SuCode like '%' || :sucode ||'%'and nvl(m.Delnote_No,'*') like '%' || :DelnoteNo ||'%'and nvl(m.Sup_InvNo,'*') like '%' || :InvNo ||'%'and nvl(m.Details,'*') like '%' || :Details ||'%'and m.posted like '%' || :posted || '%'Order by m.COMPANY_ID, m.SERIAL_NO