topic SQL Zero Output when same table referenced twice in QlikView https://community.qlik.com/t5/QlikView/SQL-Zero-Output-when-same-table-referenced-twice/m-p/1041178#M350389 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>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.</P><P></P><P>One thing which I found is it is because of the same table referenced twice in the Query which is causing issue.</P><P></P><P>EG:</P><P> select A.ACC, A.PARENT_ID, B.CHILD_ID</P><P>from CLASS AS A, CLASS AS B, RELATION</P><P>where A.ID= RELATION.PARENT_ID and</P><P> RELATION.CHILD_ID = B.ID</P><P></P><P></P><P> Note: Query works fine on SQL developer and other reporting tools</P><P></P><P>Could somebody please help.</P></BODY></HTML> Wed, 03 Feb 2016 14:30:37 GMT 2016-02-03T14:30:37Z SQL Zero Output when same table referenced twice https://community.qlik.com/t5/QlikView/SQL-Zero-Output-when-same-table-referenced-twice/m-p/1041178#M350389 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>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.</P><P></P><P>One thing which I found is it is because of the same table referenced twice in the Query which is causing issue.</P><P></P><P>EG:</P><P> select A.ACC, A.PARENT_ID, B.CHILD_ID</P><P>from CLASS AS A, CLASS AS B, RELATION</P><P>where A.ID= RELATION.PARENT_ID and</P><P> RELATION.CHILD_ID = B.ID</P><P></P><P></P><P> Note: Query works fine on SQL developer and other reporting tools</P><P></P><P>Could somebody please help.</P></BODY></HTML> Wed, 03 Feb 2016 14:30:37 GMT https://community.qlik.com/t5/QlikView/SQL-Zero-Output-when-same-table-referenced-twice/m-p/1041178#M350389 2016-02-03T14:30:37Z