Cacher is the code snippet organizer for pro developers

SELECT
    *
FROM HECUSTOMERS
INNER JOIN HEHOTELCUSTOMERS
    ON HEHOTELCUSTOMERS.HECSTMID = HECUSTOMERS.HEID
WHERE HEHOTELCUSTOMERS.HECUSTTYPE = '1'