|
Recently Repoted Results |
upit nije izvrsen zbog:- broj greske=1052
- greska=Column 'naziv' in field list is ambiguous
- upit=SELECT naziv, naslovi.sektor AS code, lastTM, trimester, sectind,
netincomeCurrent AS netincomeCurrent , netincomePrevious AS netincomePrevious , netincomeYear AS netincomeYear
, totalrevCurrent AS totalrevCurrent , totalrevPrevious AS totalrevPrevious , totalrevYear AS totalrevYear
FROM (SELECT sektor AS S, max(lastTM) AS mt FROM naslovi GROUP BY sektor) AS n2, naslovi, sektor, ind_values
WHERE n2.s = naslovi.sektor AND n2.mt = naslovi.lastTM AND naslovi.sektor = sektor.sektor
AND naslovi.kratica = income.code AND income.trimester >= n2.mt - 100
GROUP BY naslovi.sektor, trimester ORDER BY naslovi.sektor, trimester
| | | | |