I have a table of 5 columns, ticket, log_user, log_time,log_user2,Log_time 2(start attached).  I want to have one table of three columns: ticket, log_user and log_time.

I created 2 duplicate copies of the above query. I grouped the first by ticket and log_user, and aggregated it by log_time(two attached).  I grouped the second by ticket and log_user2, and aggregated it by log_time2(three attached).

I attempted to append both tables and instead of getting 3 columns, I got 4(finish attached). 

How do I append the two grouped tables so I get all users in one column, and don't get the fourth column?

[Image Can Not Be Found]