Cacher is the code snippet organizer for pro developers

SELECT
  hedocseries.hecode DocCode,
  hedocseries.heshortcut DocShortcut,
  hedocseries.hename DocName,
  hedocseries.heactive DocActive,
  payment.hecode PayCode,
  payment.heshortcut PayShortcut,
  payment.hename PayName,
  payment.heactive payActive
FROM hedocseries
INNER JOIN hedocseries payment
  ON payment.heid = hedocseries.heRecPayDcsrID
WHERE payment.hecode = 'ΕΙΣΠ'
OR payment.heshortcut = 'ΕΙΣΠ'