String query = "select k.name, k.kid, smallint(1) as group from (select * from künstler k) as k join gruppe g on k.kid = g.gid union select k.name, k.kid, smallint(0) as group from (select * from künstler k) as k join person p on k.kid = p.pid";