SQL logic in Qlikview

[usama_waqar94]

Hi Qlikies,

Please suggest workaround to implement following SQL logic in Qlikview:

SELECT DISTINCT C.LOB, FO_ACCNUMBER, ACC_NAME, ORIGINAL_NAME
FROM CUST A, PAYMENT B, LOB C
WHERE A.FO_ACCNUMBER = B.CODE
AND B.LOB = C.FO_LOB_CODE

Thanks in advance

[Mark_Little]

 Hi, 

You have a few options, the first way would to load each table with a join statement between table load making sure the key are loaded.

The second is using the SQL if that is exactly what you want and you are connecting to the database directly.

https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/SQLSer...

[usama_waqar94]

I tried using joins but output is not same when we fetch data from DB directly. Since the rows count is same as in source DB.

Please advise.

Thanks