Ποιός είναι ο χρήστης δημιουργίας και αλλαγής ενός παραστατικού.

create_user_update_user_of_document.sql

SELECT
    heDocEntries.HEDOCCODE AS Document,
    crUser.POUSERNAME AS CreateUser,
    updUsers.POUSERNAME AS UpdateUser
FROM heDocEntries
LEFT JOIN heUsers crHUsers
    ON heDocEntries.HECREATIONUSRSID = crHUsers.HEUSERID
LEFT JOIN poUsers crUser
    ON crHUsers.HEUSERID = crUser.POID
LEFT JOIN heUsers updHUsers
    ON heDocEntries.HEUPDATEUSRSID = updHUsers.HEUSERID
LEFT JOIN poUsers updUsers
    ON updHUsers.HEUSERID = updUsers.POID
WHERE heDocEntries.HEDOCCODE = 'ΑΠΠΕ-AS-0000000004'