I am facing a very strange issue with Qlikview. The Query which runs fine in SQL developer and generated results, gives No results when triggered from Qlikview.
One thing which I found is it is because of the same table referenced twice in the Query which is causing issue.
EG:
select A.ACC, A.PARENT_ID, B.CHILD_ID
from CLASS AS A, CLASS AS B, RELATION
where A.ID= RELATION.PARENT_ID and
RELATION.CHILD_ID = B.ID
Note: Query works fine on SQL developer and other reporting tools
