Cacher is the code snippet organizer for pro developers

SELECT
  BANKNOTES.HEID,
  BANKNOTES.HECODE,
  BANKNOTES.HENAME,
  'HEBANKNOTETRANSTYPES' AS TBL
FROM
  HEBANKNOTETRANSTYPES BANKNOTES
  LEFT JOIN HECOMPANIES COMPANY ON BANKNOTES.HECOMPID = COMPANY.HEID
UNION ALL
SELECT
  TRADERS.HEID,
  TRADERS.HECODE,
  TRADERS.HENAME,
  'HETRADERTRANSTYPE' AS TBL
FROM
  HECOMPANIES COMPANY
  RIGHT JOIN HETRADERTRANSTYPES TRADERS ON TRADERS.HECOMPID = COMPANY.HEID
UNION ALL
SELECT
  FUNDS.HEID,
  FUNDS.HECODE,
  FUNDS.HENAME,
  'HEFUNDACCTRANSTYPES' AS TBL
FROM
  HECOMPANIES COMPANY
  RIGHT JOIN HEFUNDACCTRANSTYPES FUNDS ON FUNDS.HECOMPID = COMPANY.HEID
UNION ALL
SELECT
  ITEMS.HEID,
  ITEMS.HECODE,
  ITEMS.HENAME,
  'HEITEMTRANSTYPES' AS TBL
FROM
  HECOMPANIES COMPANY
  RIGHT JOIN HEITEMTRANSTYPES ITEMS ON ITEMS.HECOMPID = COMPANY.HEID