title: Is it possible to convert this Outer apply to Left Join?
body: <pre><code>SELECT
      hb.custnum,hb.custname as Cname,dv.custname as [CustName],'0' + hb.cellnum as cellnum,dv.ccelnumber,
      UPPER(hb.subd) as subd,UPPER(dv.BilStAdd) as BilStAdd,hb.entity,dv.BilCtAdd
  FROM [cust] as dv
  OUTER APPLY (
      SELECT TOP 1 * FROM ##custnumtbl WHERE ##custnumtbl.CustNum = dv.custnum ORDER BY totaldue DESC
  ) hb
  Where 
      '0' + hb.cellnum &lt;&gt; dv.ccelnumber    
      or RTRIM(LTRIM(hb.custname)) &lt;&gt; RTRIM(LTRIM(dv.CustName)) 
      or UPPER(hb.subd) &lt;&gt; RTRIM(LTRIM(UPPER(dv.BilStAdd)))
      or UPPER(hb.entity) &lt;&gt; RTRIM(LTRIM(UPPER(dv.BilCtAdd)))
  </code></pre>