SELECT 
  DailyTrans.`Transaction ID`,
  DailyTrans.`Transaction Date`,
  DailyTrans.Invoice,
  DailyTrans.Unit,
  DailyTrans.`Driver ID`,
  DailyTrans.`Driver Name`,
  DailyTrans.`Location ID`,
  DailyTrans.`Location Name`,
  DailyTrans.`Location City`,
  DailyTrans.`Location State/Province`,
  DailyTrans.`Transaction Fee`,
  DailyTrans.`Product Code`,
  DailyTrans.`Price Per Unit`,
  DailyTrans.Retail_PPU,
  DailyTrans.Quantity,
  DailyTrans.Amount,
  DailyTrans.`Card Number`,
  DailyTrans.Chain_Desc,
  DailyTrans.subfleet,
  DailyTrans.PAID_RETAIL,
  DailyTrans.PAID_RETAIL_DATE,
  DailyTrans.PAID_RETAIL_REF,
  DailyTrans.TID,
  (DailyTrans.`Transaction Fee` + DailyTrans.Amount) AS TotalAmount,
  DailyTrans.ChainID,
  CARRIER_PROFILE.BILL_TO,
  CARRIER_PROFILE.EMAIL,
  CARRIER_PROFILE.NAME,
  CARRIER_PROFILE.CONTRACT_ID,
  DailyTrans.`Sub Fleet`,
  DailyTrans.`Discount Type`,
  DailyTrans.`Direct Bill / Funded`

FROM DailyTrans

LEFT JOIN `CARRIER_PROFILE` ON CARRIER_PROFILE.`SUBFLEET` =DailyTrans.`Sub Fleet`

  WHERE 
  `Transaction Date` BETWEEN '2025-12-01'  AND '2025-12-03' 
  AND DailyTrans.`Sub Fleet`='138' 
ORDER BY DailyTrans.`Transaction Date` DESCNo Record Found