Different SQL results in qlikview

[zhadrakas]

Hello all,

i have the following SQL in QlikView.

SQL SELECT
int(N.QSOART) as DAN
int(AZP2AR) as ref_DAN
FROM
DATEIEN.ARLAZUP N
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:

 

TESTING:

Tested in DB-Visualizer with JDBC driver:
-> should be null but that’s not the big deal

Tested in DB-Visualizer with ODBC driver:

-> works correct

Tested in QlikView with JDBC driver:

-> should be null but that’s not the big deal

Tested in QlikView with ODBC driver:

-> definitely works wrong.

This problem occurs if the Source Data int(AZP2AR)is a NULL value.

My question: How does Qlikview get this REF_DAN_01?

[awhitfield]

Hi Tim,

what's in the load part of the script? You have only post the SQl select.

Adny

[zhadrakas]

here is my qvw. i have only removed the Connection strings.