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,
  FUEL_PROCESS.REBATE,
  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`,
  FUEL_PROCESS.REBATE,
  (FUEL_PROCESS.REBATE * FUEL_PROCESS.QTY) as payout
  
FROM DailyTrans
LEFT JOIN `CARRIER_PROFILE` ON CARRIER_PROFILE.`SUBFLEET` =DailyTrans.`Sub Fleet`
LEFT JOIN FUEL_PROCESS on FUEL_PROCESS.SUBFLEET=CARRIER_PROFILE.`SUBFLEET` AND FUEL_PROCESS.TRANS_DATE=DailyTrans.`Transaction Date` and FUEL_PROCESS.PRODUCT_CODE=DailyTrans.`Product Code`

  WHERE 
  `Transaction Date` BETWEEN '2026-01-26'  AND '2026-01-25' 
  AND DailyTrans.`Sub Fleet`='140' 
  GROUP BY DailyTrans.TID
ORDER BY DailyTrans.`Transaction Date` ASCNo Record Found