upit nije izvrsen zbog:<UL><li>broj greske=1054<li>greska=Unknown column 'ind_values_ttm.employes' in 'field list'<li>upit=
SELECT industrija.naziv as naziv, industrija AS code, income.code AS code2, ind_values_ttm.employes as em,
  SUM(dilutedavg) AS dilutedavg, SUM(cijena * income.dilutedavg) AS marketcap
FROM naslovi, industrija, income, dionice_year , ind_values_ttm
WHERE naslovi.sektor = '500' AND naslovi.industrija = industrija.ind AND ind_values_ttm.sectind = industrija.ind
  AND naslovi.kratica = income.code AND income.trimester = naslovi.lastTM AND ind_values_ttm.trimester = naslovi.lastTM
  AND dionice_year.datum = (SELECT max(datum) FROM dionice_year) AND income.code = dionice_year.code
 
GROUP BY industrija ORDER BY industrija</UL>