sql - Include a string in Select Query -
    i'm wondering can query below?   select america, england, distinct (country) tb_country   which (my intention to) display :   america   england   (list of distinct country field in tb_country)   so point display (for example) america , england if distinct country field returns nothing. need query list select dropdown, , give sticky values user can pick, while allowing add new country wish.   it goes without saying, should 1 row in tb_country has value of america or england, not show duplicate in query result. if tb_country has list of values :   germany   england   holland   the query output :   america   england   germany   holland          you need use union:   select 'america' country union select 'england' country union  select distinct(c.country) country   tb_country c   union remove duplicates; union not (but faster it).   the data type must match each ordinal position in select clause.  meaning, if first column in first query int, first column unioned sta...