Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SQL Zero Output when same table referenced twice

Hi All,

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

Could somebody please help.

0 Replies