How to display this SQL query as one table -

very basic sql question. wan't display output of following query 1 table instead of two:

select players.name players inner join teams on players.team = teams.name teams.staysat = 'ambassador' , teams.checkin not null;  select fans.name fans fans.staysat = 'ambassador' , teams.checkin not null; 

how can rewrite players name , fans name printed 1 continuous list?

you need put union between them, it's simple

select players.name players inner join teams on players.team = teams.name teams.staysat = 'ambassador' , teams.checkin not null; union select fans.name fans fans.staysat = 'ambassador' , teams.checkin not null; 

if don't want omit duplicate names should put union all