select users.username, shell_history.command, shell_history.history_file from users join shell_history using (uid);