OK, so I've got 2 tables
my actual tables are more complex than this, but it will serve for the time being.
What I'm trying to do is to create a query that will provide me with a table showing the content of the audit table, only instead of the UIDFrom, I want to see the UIDFrom person's last name -- and instead of UIDTo, I want that person's last name.
I know that I could just do three separate queries for each row of the audit table, but that seems very ineffieicnt.
Is there a better way to do this?