select ID, 'Actor' as Career, Name from Actor union all select ID, 'Singer' as Career, Name from Singer