title: Getting Null Values on a Left Join
body: <p>I have the query below. I am trying to left join to another table. I know for a fact that the query should return values but the values are coming back as null. Does anyone see anything I am doing wrong? My brain is fried at this point. </p>
  
  <pre><code>SELECT 
      ss.NDC,
      ss.ShipToAddressNo,
      ss.QuantityShipped,
      c.AccrualType,
      ss.ExtendedPrice ExtendedPrice,
      c.AccrualAmount CBAccrualAmount
  FROM
      SalesSummary ss left join ChargebackAccruals c on
          ss.ClassOfTrade = c.TradeClass and
          c.AddressNo is null and
          c.ShipTo is null and
          c.ShortItemNo is null and
          c.LotNumber is null and
          ss.InvoiceDate = @RunDate and
          ss.InvoiceDate between AccrualBeginDate and AccrualEndDate
  </code></pre>