SELECT
  FC.FinCategoryID,
  FC.FinCategoryName,
  FC.LabourNetBranch,
  FC.ProductCategory,
  FC.PaymentMethod,
  FC.PastelSubAccount,
  U1.FullName AS DebtorClerk
FROM
  taFinCategory AS FC
    LEFT JOIN taUsers AS U1 ON (U1.UserID = FC.DebtorClerkID)