Hello all,
I am having a problem with the setFetchLimit on Oracle. When I use
joined tables that have fields with the same name i get the error:
Error code 918, SQL state 42000: ORA-00918: column ambiguously defined
with a query similar to the next one:
select * from ( select tid.*, ROWNUM rnum from (
SELECT .... LEFT JOIN
ENTIDADE t1 ON (t0.ENTIDADE_ID_ENTIDADE = t1.ID_ENTIDADE) WHERE
t0.FISC_ID_FISCALIZACAO = 6103 ORDER BY t0.DT_AVERIG)
tid where ROWNUM <=15) where rnum > 0
Any way around this?
Thanx
Bruno
