znaći imam tablicu
id,kolona1,kolona2,kolona3,indikator
indikator može biti 'a' ili 's'
select sum(a),sum(s) from
(
select sum(id) as a,sum(0) as s from prva where ind='a'
union
select sum(0) as a,sum(id) as s from prva where ind='s'
)
i dobijem, ako ne stavim prvi select
a,s
33,0
0,77
i sad još moram zbrojiti u svakoj koloni i dobiti 33, i dobiti 77.
ako stavim iznad select, dobijem grešku: Every derived table must have its own alias
greška 1248.