This content has been marked as final. Show 2 replies
i have the following SQL in QlikView.
int(N.QSOART) as DAN
int(AZP2AR) as ref_DAN
INNER JOIN DATEIEN.ARZUSP ON N.QSOART = AZSOAR
where N.QSOART in (555807, … ,472968);
I have experienced different results of this SQL in Qlikview and my DB-Viewer (DB-Visualizer). So I began testing
MY SOURCE DATA:
Tested in DB-Visualizer with ODBC driver:
Tested in QlikView with JDBC driver:
Tested in QlikView with ODBC driver:
This problem occurs if the Source Data int(AZP2AR)is a NULL value.
My question: How does Qlikview get this REF_DAN_01?