Pylon SQL - Get Transaction Types
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