Hello

If I run each query seperatly everything works. If i put then in a union, it fails. How do I fix it?

select 'förste kapten', fornamn, efternamn
from flight_rutt fr
inner join anstalld a ON (a.anstnr=fr.kapten1)
where flightnr = 'SK405'
UNION
select 'andre kapten', fornamn, efternamn
from flight_rutt fr
inner join anstalld a ON (a.anstnr=fr.kapten2)
where flightnr = 'SK405'
UNION
select 'vardinna', fornamn, efternamn
from flight_vardinna fv
inner join anstalld a ON (a.anstnr=fv.anstnr)
where flightnr = 'SK405';



[Non-text portions of this message have been removed]