select k.kid, k.name, 0 as type from person p, künstler k where p.kid = k.kid
union
select k.kid, k.name, 1 as type from gruppe g, künstler k where g.kid = k.kid