Suppose I have the next two lines:

select username, password from tablename;
select username, hostname from tablename;

suppose I want to add another column before the username. can I vertically
select the u's from two lines of username and start adding vertically so the
result after vertically adding will be:

select DATE, username, password from tablename;
select DATE, username, hostname from tablename;

Thanks.