I have a table with the users and credentials for an application. Auditors want me to generate a report to make it so that they can audit when user accounts have been created and who they were created by.
So the table is: sysid, userid, password, created_by, creation_date
The created_by column captures the userid of the person that created the account thru the application and the creation date.
I need to return every userid in the table (only 19 records) and display any records that were created by another id. In essence, there is only one administrator that has created all of the records in the table, but the auditors want to know that the other userids did not create a record.
Does this make sense? I believe that it can be accomplished with a join on the same table, but I am not sure of the syntax to make this happen.