upit nije izvrsen zbog:<UL><li>broj greske=1054<li>greska=Unknown column 't2.cijena' in 'field list'<li>upit=
CREATE TEMPORARY TABLE  ts (
  sektor int(11) default NULL,
  industrija int(11) default NULL,
  code varchar(8) default NULL,
  a double default NULL,
  b double default NULL
) ENGINE=MEMORY (

SELECT t0.sektor AS sektor, t0.industrija AS industrija, t0.code AS code, sum(t2.cijena * income.dilutedavg) AS a, sum(t3.fcf4t) AS b,
	t0.industrija_naziv AS industrija_naziv, t0.sektor_naziv AS sektor_naziv, t0.firma_naziv AS firma_naziv
FROM (
  select lastFY, zadnjiTM, kratica as code, firma AS firma_naziv, naslovi.sektor AS sektor, sektor.naziv AS sektor_naziv, naslovi.industrija AS industrija, industrija.naziv AS industrija_naziv, guidance_RY, guidance_EY
  from naslovi, sektor, industrija
  where zadnjiTM >= (select max(zadnjiTM) from naslovi) - 50 AND naslovi.sektor = sektor.sektor AND naslovi.industrija = industrija.ind
	) as t0,
	current
WHERE t0.code = current.code 

GROUP BY t0.sektor, t0.industrija, t0.code WITH ROLLUP
)
</UL>