SELECT
  fldTrlrSCAC [Fleet],
  fldTrlrNumber [Unit #],
  fldTrlfPurchaseDate [Purchase DT],
  fldTrlfPurchasePrice [Purchase Price],
  fldTrlrUsage [Intended Use]
FROM tblTrailerMain
    join tblTrailerFinancial on fldTrlrID=fldTrlfTrlr
WHERE isnull(fldTrlrSCAC,'') <> '#SYS'
  AND fldTrlfPurchaseDate is not null
  AND fldTrlfPurchaseDate >= '{1}'
  AND fldTrlfPurchaseDate < '{2}'
ORDER BY 1,2