SQL Code:
  1. SELECT     dbo.MWorkOrder.MWORefNo, dbo.MWorkOrder.PWORefNo, dbo.MWorkOrder.DateOfService, dbo.MWorkOrder.Remarks, dbo.WOList.Category,
  2.                       dbo.WOList.Dept, dbo.WOList.Mac_Code, dbo.WOList.Status, dbo.BreakDownReport.BRRefNo
  3. FROM         dbo.WOList INNER JOIN
  4.                       dbo.MWorkOrder ON dbo.WOList.Ref_No = dbo.MWorkOrder.PWORefNo LEFT OUTER JOIN
  5.                       dbo.BreakDownReport ON dbo.BreakDownReport.MWORefNo = dbo.MWorkOrder.MWORefNo
  6. WHERE Status = 'Completed' AND Category LIKE '%' AND dbo.BreakDownReport.BRRefNo <> 'Null' ORDER BY dbo.MWorkOrder.MWORefNo

RETURN ME CORRECT RECORD WHICH dbo.BreakDownReport.BRRefNo <> 'Null'But why the SQL BELOW cannot return me the record where dbo.BreakDownReport.BRRefNo = 'Null'


SQL Code:
  1. SELECT     dbo.MWorkOrder.MWORefNo, dbo.MWorkOrder.PWORefNo, dbo.MWorkOrder.DateOfService, dbo.MWorkOrder.Remarks, dbo.WOList.Category,
  2.                       dbo.WOList.Dept, dbo.WOList.Mac_Code, dbo.WOList.Status, dbo.BreakDownReport.BRRefNo
  3. FROM         dbo.WOList INNER JOIN
  4.                       dbo.MWorkOrder ON dbo.WOList.Ref_No = dbo.MWorkOrder.PWORefNo LEFT OUTER JOIN
  5.                       dbo.BreakDownReport ON dbo.BreakDownReport.MWORefNo = dbo.MWorkOrder.MWORefNo
  6. WHERE Status = 'Completed' AND Category LIKE '%' AND dbo.BreakDownReport.BRRefNo = 'Null' ORDER BY dbo.MWorkOrder.MWORefNo

THANKS FOR HELPS !!