[mysql] sklic na rezultat

SELECT x.ime, x.priimek, x.prihodek, x.prihodek * 3.14 AS ilikepi FROM
(SELECT ime, priimek, (select moja_funkcija()) AS prihodek FROM zaposleni) x

SELECT ime
     , priimek
     , fun AS prihodek
     , fun * dodatno as dodatna kolona
FROM (
      SELECT ime
           , priimek
           , (SELECT moja_funkcija()) AS fun,
      FROM zaposleni
     )

CREATE VIEW W_ZAPOSLENI AS
  SELECT ime
       , priimek
       , (SELECT moja_funkcija()) AS fun,
    FROM zaposleni
;
SELECT ime
     , priimek
     , fun AS prihodek
     , fun * dodatno as dodatna kolona
FROM W_ZAPOSLENI