Cacher is the code snippet organizer for pro developers

SELECT
  heRetDocEntries.HEDOCCODE AS DocCode,
  heRetDocEntries.HEREFNUMBER AS RefNumber,
  heRetDocEntries.HEENTRYDATE AS EntryDate,
  heRetDocEntries.HETTOTALVAL AS Total,
  heRetDocEntries.HERETAILSTATION AS RetailStation,
  heResOrders.HEORDERNO AS OrderNo,
  heResServSections.HECODE AS ServingSectionCode,
  heResServSections.HENAME AS ServingSection,
  hePDARoles.HECODE AS PDACode,
  hePDARoles.HENAME AS PDAName,
  poUsers.POUSERNAME AS UserName,
  heBusinessUnits.HENAME AS BU
FROM heRetDocEntries
LEFT JOIN heResOrders
  ON heResOrders.HEID = heRetDocEntries.HERORDID
LEFT JOIN heResServSections
  ON heResServSections.HEID = heResOrders.HERSSSID
LEFT JOIN hePDARoles
  ON heResServSections.HEID = hePDARoles.HERSSSID
INNER JOIN poUsers
  ON heRetDocEntries.HECREATIONUSRSID = poUsers.POID
LEFT JOIN heBusinessUnits
  ON heRetDocEntries.HEBSUTID = heBusinessUnits.HEID