must name this expression with a column alias
Hvad laver jeg fejl herNår jeg prøver at lave det her view
drop view antalVarePaLagere;
create view antalvarePaLagere as select varenr ,(SELECT SUM(qoh) as qohlager from lager la, vare va where va.varenr=la.varenr),
(SELECT SUM(qoh) as speqoh FROM speditorlager spe, vare va where va.varenr=spe.varenr),
(SELECT SUM(la.qoh+spe.qoh) as qohalle From lager la, leverandorlagerindhold levlag, speditorlager spe, vare va where va.varenr=spe.varenr AND va.varenr=levlag.varenr AND va.varenr=la.varenr)
FROM vare va
ORDER BY varenr;
Får jeg denne her fejl
ERROR at line 1:
ORA-00998: must name this expression with a column alias